Showing results for 
Search instead for 
Did you mean: 
asanb Frequent Visitor
Frequent Visitor

Pie chart-formatting large data

I'm having trouble creating the pie charts that I need based on how my data is formatted. I have 22 locations and 2 different data columns. Therefore, I need 22 pie charts with the 2 percentages displayed. However, my locations are all in one column and not separated per location. Is there a way to make the different pie charts per location in Power BI or is it easier to change the formatting on the excel sheet and work from there? 

Microsoft v-evelk

Re: Pie chart-formatting large data



I suppose you can use DAX to modify and adjust your input data before they will be send to Power BI.


Kind Regards,


Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals

Super User I
Super User I

Re: Pie chart-formatting large data

I think that what you're suggesting is something along the lines of small multiples (also know as multivariate reporting)?

Power BI does not have support for this, although there are a few custom visuals in the maretplace that do offer it (but not for pie charts). It is one of the most highly requested features for Power BI but there's no sign of it yet.

If your 22 location values are known and are not likely to be dynamic, the simplest (not necessarily fastest or easiest to maintain) way to to this without any development would be:

  1. Add your visual to the canvas with measures
  2. Add your location field to the visual filters
  3. Select your first location in the filter
  4. Copy/paste the visual and change the filter of that one to match the second location
  5. Repeat step 4 for all other locations

There is a better guide published by the Power BI team here.

Another alternative is to consider if a pie chart is the best visual for what you're trying to communicate. Pie charts are often not regarded as an optimal way of showing proportion, when a bar chart might suffice. This is obviously your call, but if you can change your visual type, then the 100% Stacked Bar Chart might fit your needs.

Hopefully this helps you out - it's one of the killer features missing in Power BI that should be easy, but currently isn't.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors