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 |
---|---|
77 | |
67 | |
65 | |
50 | |
27 |