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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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

Anonymous
Not applicable

How does this work? What do I see?

MAwwad
Super User
Super User

Create another SWITCH measure to do grouping

Anonymous
Not applicable

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.