Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.....
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!