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,
I have pie chart that consists dozens of categories in the legend. Is there any way to automatically merge categories whose percentage is less than a certain value (for example less than 2 %) into one category (let's say named "Others"). As this is a live data, I cannot simply merge the category manually because the percentage could always be changed.
Thank you for your help.
Vano.
Solved! Go to Solution.
Hi, @Anonymous
What is your current data source?
If your data model is liveconnect,I'm afraid that it is impossible to do that in a pie chart . Amitchandak 's method isn't feasible for pie chart visual. As of now, the legend of the pie chart does not support the measure type field.
If you don’t mind converting the data model into import mode, you can create a calculated column as below:
Defect Type2 =
VAR percentage =
'Table'[Value] / SUMX ( ALL ( 'Table' ), 'Table'[Value] )
RETURN
IF ( percentage <= 0.02, "others", 'Table'[Defect type] )
Best Regards,
Community Support Team _ Eason
Hi, @Anonymous
What is your current data source?
If your data model is liveconnect,I'm afraid that it is impossible to do that in a pie chart . Amitchandak 's method isn't feasible for pie chart visual. As of now, the legend of the pie chart does not support the measure type field.
If you don’t mind converting the data model into import mode, you can create a calculated column as below:
Defect Type2 =
VAR percentage =
'Table'[Value] / SUMX ( ALL ( 'Table' ), 'Table'[Value] )
RETURN
IF ( percentage <= 0.02, "others", 'Table'[Defect type] )
Best Regards,
Community Support Team _ Eason
@Anonymous , One of the quick things I can think of is TOPN with Other
https://www.youtube.com/watch?v=UAnylK9bm1I
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |