Ravindra BagaleCourses & study guides Track your progress

Guides

Choose the Right Chart Type in Power BI

By , Power BI & Data Analytics trainer LinkedIn Published: Last updated:

Choose the chart from the question, not from the icon that looks impressive. Compare with a bar, trend with a line, a small mix with a 100% bar or a tiny donut, one KPI with a card, exact crossings with a matrix.

Friends! Reports get loud when every visual is a pie. Why? The author picked a shape before a question. How? We walk a fictional FreshBasket page — cities, months, channel mix, one sales number — and we throw out 3D and crowded pies. Question first, then the visual.

Quick answer

Vertical picker:

  1. Compare categories → clustered bar, sorted by the measure.
  2. Trend over time → line, Date table on the axis.
  3. Part of a whole, few parts → 100% stacked bar, or a donut with two to four slices.
  4. One number → card or KPI visual.
  5. Exact grid → matrix or table.
  6. If you are unsure, a sorted bar is the calm default.

Real example: what the owner actually asks

FreshBasket has a shop in Mumbai and a shop in Pune. Saturday sales: Mumbai 1000 (rice 500, oil 200, atta 300), Pune 160 (rice 100, sugar 60). The owner also has a phone bill: Mumbai 499, 499, then 699 in March. Pune stays 399.

Why the chart follows the question:

  1. "Which city sold more?" Rows are two cities. A sorted bar shows Mumbai longer than Pune. A pie makes you compare angles for no reason.
  2. "Is the phone bill climbing?" That is a line across Jan, Feb, Mar. Mumbai's line steps up to 699. Pune's line stays flat. Not a bar of cities, and not a pie of months.
  3. "What share is rice versus oil versus atta in Mumbai?" Three parts. A 100% bar or a small donut is enough. Eight products would go back to a bar.
  4. "What is the bill this month?" One number. A card says 699. A chart with one slice is theatre.

What happens when you build it: the City slicer on Mumbai removes Pune's rows before the visual draws. The bar has one category. Clear the slicer and both cities return. If you put the phone bill and the sales on one axis, 1000 and 699 look like the same kind of money. They are not. Sales come in. The bill goes out. Two visuals, two titles.

What do I need before this guide?

Before and after (look at the tables first)

Before chart choice Two city sales shown without a clear chart.

Before

After chart choice Bar chart chosen for city comparison.

After

Start with the sentence

Question then chart Start with compare, trend, part-to-whole, or one KPI, then pick the visual. Question what? Chart fit Reader gets it pick

Ask the question first: compare, trend, part of a whole, or one KPI — then choose the chart.

Question Visual FreshBasket example Leave it
Which city is higher? Clustered bar Sales by City Pie with eight cities
What happened over months? Line Sales by Year-Month A bar for every day of the year
What is the mix? 100% stacked bar Channel share by City 3D pie
What is the number? Card or KPI AOV, orders A table with one cell
What is the exact crossing? Matrix City by month A chart with fifty labels
  1. Write the question in the visual title, not only in your head.
  2. If the title is “Sales”, you have not chosen yet.

Bars and lines

Bar vs line Bars compare categories; a line shows a trend over time. Cities bars Months line Not pie many slices fit

Bars compare categories such as City; a line shows a trend across months.

  1. Horizontal bar when the category name is long (store name, product).
  2. Sort the bar by the measure unless the category has a real order, such as months.
  3. Column chart for a short list of months side by side.
  4. Line chart when the reader should see rise and fall. The axis must be time from the Date table.
  5. Do not use a line to connect cities. Cities are not a sequence.

Mix, and what to refuse

Charts to avoid Skip 3D and a pie with many categories; a sorted bar is the calm default. 3D no Pie 8+ no Sorted bar yes avoid

Skip 3D and a pie with many slices. A sorted bar is the calm default when you are unsure.

  1. A donut is acceptable for two to four parts: Online and Store, or three channels.
  2. Eight products in a pie make the reader estimate angles. Use a sorted bar.
  3. 3D charts bend the lengths. Skip them.
  4. A dual axis that shares no units (rupees and minutes) needs a caption, or two charts. Pretty is not the same as readable.
  5. A map only when the question is about place. City names on a bar are often clearer.

One page that does not shout

For a FreshBasket monthly review:

  1. Top: three cards (sales, orders, AOV).
  2. Middle: line of sales by month.
  3. Beside it: bar of sales by city, sorted.
  4. Bottom: matrix only if someone must read the cells.

That is enough. The next guides build the matrix, the cards and the hover detail.

Ghabru naka — if a classmate cannot answer the question from the visual in ten seconds, change the chart, not the colour theme.

Mistakes and calm fixes

Symptom Likely cause Fix
Pie no one can read Too many slices Sorted bar
Line looks random Categories on the axis Use a bar
Trend is jagged noise Daily grain Month on the axis
Two scales, one chart Dual axis Split the visuals

Ravindra Bagale's Tip

Interview line: “Comparison is a bar, trend is a line, part-to-whole with few categories is a 100% bar or a small donut, one KPI is a card. I sort bars by value.” Do not defend a pie with twelve products. Got it?

Practice task

  1. Write four questions on paper.
  2. Build one visual each, using the table above.
  3. Delete one chart that does not match its question.
  4. Sort the city bar descending.
  5. Retitle every visual as a question or a plain answer.

Learn it properly

Course lesson:

Related guides: Panes · First dashboard

Got it? The question picks the chart. A sorted bar beats a crowded pie. Next: the matrix, when the reader needs the grid. Let's continue.

Frequently asked questions

Bar or column?

Bar (horizontal) when labels are long. Column (vertical) for a few short categories or a short run of months.

When is a pie acceptable?

Rarely. Two to four parts of a whole can be a donut. Many cities or products should be a sorted bar.

What about 3D charts?

Skip them. They make lengths harder to compare.

Line chart with 365 days?

Fine for a trend if the line stays readable. For category labels, do not use a line.

Two measures, two questions?

Relationship between two measures can be a scatter. Do not force them onto one confusing dual axis just to save space.

Course lesson?

Choose the right chart, in the visuals chapter.