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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors