Creating Charts and Visuals in Power BI: Bar, Line, Map and KPI Cards (Episode 6) (Updated May 2026)

NASSCOM-Deloitte project 1.25 million AI and analytics-skilled professionals needed in India by 2027, and every single data analyst job description on Naukri lists Power BI as a primary skill. Episode 6 is where you go from knowing what Power BI is to actually building something useful in it. Charts and visuals are the output layer that makes data decisions happen — the Bar Chart that shows which product is underperforming, the Line Chart that reveals the revenue trend, the Map that surfaces which city is the biggest opportunity. This episode covers every standard visual in Power BI Desktop with practical formatting guidance so your reports look professional, not just functional.

▶ Watch on YouTube

The Power BI Visualizations Pane: Your Chart Builder

The Visualizations pane in Power BI Desktop is on the right side of the screen. It contains all available chart types as icons — hover over any icon to see its name. Below the chart icons are three tabs: Fields (what data goes into the visual), Format (how the visual looks), and Analytics (reference lines, trend lines, forecasts). To add any visual to your report: click the visual icon in the pane, and a placeholder appears on the canvas. Then drag fields from the Fields pane on the far right into the field wells at the bottom of the Visualizations pane. The field wells change depending on the visual type — a Bar Chart has Axis, Values, and Legend wells; a Map has Location, Latitude, Longitude, and Size wells. Power BI is drag-and-drop at its heart: drag the right field into the right well and the visual builds itself. The skill is knowing which visual to use for which analytical question — the rest is formatting.

Bar and Column Charts: The Workhorses of Business Reporting

Bar Charts (horizontal) and Column Charts (vertical) are the most commonly used visuals in Power BI dashboards because they answer the most common business question: which category is biggest, and by how much? Use a Clustered Column Chart when comparing multiple categories side by side (sales by region, revenue by product category). Use a Stacked Column Chart when you want to show both the total and the composition simultaneously (total sales split by product type). Use a 100% Stacked Bar for proportion comparisons (what percentage of each region's sales comes from each product). The formatting rules for professional-quality bar charts: turn off the gridlines (they create visual noise); add data labels to show the actual values on bars; sort bars from largest to smallest using the Sort options in the visual header; and use a single consistent colour unless colour is encoding a data variable. Never use the rainbow colour-per-bar default — it implies different categories are qualitatively different when they are usually the same type of thing.

Line Charts and Area Charts: Showing Trends Over Time

Line Charts are the standard tool for time-based data — monthly revenue, weekly website visits, daily production count. In Power BI, drag a Date field to the X-Axis and a numeric measure to the Y-Axis. Power BI automatically detects date hierarchies — Year, Quarter, Month, Day — and adds drill-down arrows to the visual so viewers can click from annual to monthly to daily trends. Area Charts fill the area under the line with colour — use these when you want to emphasise the magnitude of the trend (total volume over time) rather than just the direction. For multi-line charts comparing two or more series, drag a categorical field (Product Category, Region) to the Legend well — Power BI creates one line per category with automatic colour coding. The most important formatting step for line charts: turn on Markers (small dots at each data point) so viewers can see exact data positions at each period; and add a smooth curve only if your data is genuinely continuous — do not smooth discrete monthly data points as it implies interpolation.

KPI Cards, Gauge and Donut Charts: Summarising What Matters

KPI Cards are the first thing a manager looks at on any dashboard — they summarise the most important number in the largest text on the page. In Power BI, the Card visual shows a single measure value with a label. Drag your measure (Total Revenue, Total Units Sold, Customer Count) to the Fields well and the number appears large and centred. Format the number using Display Units (Thousands, Millions) to keep it readable. The Multi-Row Card shows multiple measures side by side — useful for a summary panel at the top of your report. The Gauge Chart shows a metric against a target with a dial visual — the arc fills from minimum to maximum and the needle points to the current value. Set the Target Value field to your goal and the Gauge colours itself green, yellow, or red automatically. Donut Charts are useful for composition analysis — what percentage of total sales comes from each product? Use a Donut rather than a Pie because the central hole allows you to add a total label inside, giving context that a Pie chart cannot.

Map Visuals and Slicers: Geography and Interactivity

The Map visual in Power BI plots geographic data using location names or latitude/longitude coordinates. Drag a City or State field to the Location well and a numeric measure to the Size well — Power BI geocodes the location names automatically and draws bubbles sized proportionally to the measure. For Indian data, use state names in English exactly as Microsoft's Bing geocoder expects them (Maharashtra, not MH; Tamil Nadu not TN). The Filled Map visual fills entire state or country areas with colour gradients — useful for showing regional density or market penetration across India's 28 states. Slicers are the most powerful interactive element in any Power BI report — they are filter controls that update every other visual on the page when a user clicks them. Add a Slicer, drag a categorical field (Year, Region, Product Category) to the Field well, and every chart on the page now responds to that selection. Slicers can be single-select (default), multi-select (Ctrl+click), or date range pickers for time-period filtering.

Formatting Your Power BI Report to Professional Standard

Professional Power BI reports follow consistent formatting conventions that make the difference between a report that managers trust and one they ignore. The five rules: First, use a consistent colour palette — two or three colours maximum, matching company brand colours. Second, never use dark text on dark backgrounds (dark-on-dark text is unreadable). Third, every visual needs a clear title — not "Sum of Revenue" (the default) but "Monthly Revenue by Region". Fourth, use white backgrounds for report pages — dark mode dashboards look impressive in demos but cause eyestrain in daily use. Fifth, remove unnecessary visual borders and shadows — clean flat design communicates confidence. Power BI's built-in themes (View > Themes) include several professional presets; or import a custom theme JSON file that matches your company's branding. ABC Trainings' Power BI program at Wagholi, Hadapsar, Cidco, Osmanpura and Sangli includes a live report-building session where students apply all these formatting principles to a real dataset. CMYKPY scholarship of ₹6,000–₹10,000 available for eligible students. Call 7039169629 or WhatsApp 7774002496.

FAQs

How many charts can I put on one Power BI report page?

There is no hard limit, but best practice is 6–8 visuals per report page. More than 10 visuals creates cognitive overload for the viewer and slows report rendering. Keep each page focused on one business question — use multiple pages for different topics. A common layout: 3–4 KPI cards at the top, one large chart in the centre, two supporting charts below, and one or two slicers on the left or top.

What is the difference between a Bar Chart and a Column Chart in Power BI?

In Power BI, a Bar Chart has horizontal bars (categories on the Y-axis) and a Column Chart has vertical bars (categories on the X-axis). Use Column Charts for time-based comparisons (monthly revenue) where time naturally flows left to right. Use Bar Charts for category comparisons (products, regions) where long category labels are easier to read when placed horizontally. Both use the same fields; the orientation choice is purely about readability.

Why does my Power BI map visual not show Indian cities correctly?

Power BI geocodes location names using Microsoft Bing Maps. For Indian cities, use the full English name (Mumbai, not Bombay; Bengaluru not Bangalore for newer data). Add a Data Category to the column in Power Query: select the city column, go to Column Tools > Data Category > City. Also set the Country/Region field in the Location well to "India" to help Bing disambiguate cities that exist in multiple countries (Chennai vs Chennai, Tennessee USA).

What is the best Power BI visual for showing sales by state across India?

The Filled Map visual is best for showing data by Indian state — it colours each state based on its value using a gradient scale. Use the state name in English exactly as Bing expects (Maharashtra, Karnataka, Uttar Pradesh). For city-level data, the Map visual with bubble sizing is more effective since individual cities cannot be coloured in a Filled Map. For both visuals, ensure your location data has no spelling errors — even one typo causes that location to disappear from the map.