Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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:
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.
Regards,
Daniel
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Hello,
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
pbicvsupport@microsoft.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.