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

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.

Reply
Power_BI_Adapt
Resolver I
Resolver I

How to cluster data in circle chart?

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. 

Power_BI_Adapt_0-1670944311491.png

Any suggestion how to arrange?

 

Thanks!

Kind regards,

1 ACCEPTED 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.....

View solution in original post

5 REPLIES 5
Vilmar
Resolver I
Resolver I

Veja se o anexo ajuda

 

 

Vídeo sem título ‐ Feito com o Clipchamp.gif

How does this work? What do I see?

MAwwad
Super User
Super User

Create another SWITCH measure to do grouping

How would this look likke with a sample set of data?

Power_BI_Adapt_0-1671093941926.png

 

Switch(TRUE(), Values(Name of Supplier) = "ABC"," Group 1",
                        Values(Name of Supplier) ="BCD"," Group 1",
                        Values(Name of Supplier) ="CDE","Group 1",

etc.....

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.