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.
Hi all!!
I need some help with a Pie Chart.
There are several slicers on the page (date, location, consultant, .....), and 17 groups of data (let's call "Product Families").
The information to be shown is the total value of each family.
Depending on the filters applies (slicres), the ranking of the families change.
I must show the top 5, and aggergate all others on a pie chart (always 6 categories are shown - 1, 2, 3, 4, 5 and others).
Has anyone solved this already?
I have already a measure that indicates if it will be shown as "Family A" or "Others", but I can't put it on the chart...
Solved! Go to Solution.
Hi @mcemim ,
As I know, pie chart need to group on column, but slicer can't work on calculated column, so if slicer will change the rank in column, this can't be achieve currently. One workaround is that you need to use two pie charts to show them, one is top 5, another is "other". You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Take a look at this post where the same problem was solved.
https://community.powerbi.com/t5/Desktop/Pie-Chart-Top-5-Rest-named-Other/m-p/738810
Thank you for the indication!
But somehow, it didn't work for me...
Hi @mcemim ,
As I know, pie chart need to group on column, but slicer can't work on calculated column, so if slicer will change the rank in column, this can't be achieve currently. One workaround is that you need to use two pie charts to show them, one is top 5, another is "other". You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |