Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Dear All,
I created a circle chart, as mentioned below, with a bunch of values.
I would like to show the first 5-10 values seperately, but how can I cluster the rest of the values to one value, labelled for instance like 'Others'. The values are populated by a measure.
Any suggestion how to arrange?
Thanks!
Kind regards,
Solved! Go to Solution.
Switch(TRUE(), Values(Name of Supplier) = "ABC"," Group 1",
Values(Name of Supplier) ="BCD"," Group 1",
Values(Name of Supplier) ="CDE","Group 1",
etc.....
How does this work? What do I see?
Create another SWITCH measure to do grouping
How would this look likke with a sample set of data?
Switch(TRUE(), Values(Name of Supplier) = "ABC"," Group 1",
Values(Name of Supplier) ="BCD"," Group 1",
Values(Name of Supplier) ="CDE","Group 1",
etc.....
User | Count |
---|---|
98 | |
75 | |
73 | |
49 | |
26 |