Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
asanb
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? 

2 REPLIES 2
dm-p
Super User
Super User

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.

Regards,

Daniel

 





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

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)




v-evelk
Employee
Employee

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.