Forum Discussion
How to stop sunburst layers to aggregate data
Hi,
I created a sunburst diagram and want to colour each cell based on the value from 1-5.
However, only the outer layer shows data in that range, the inner circles are aggregating the data from outer layers even if I select to show average instead of sum.
Is it possible to set it up?
Thanks
Hi KG_90 ,
I tried my best with this visual object not so good customization features and it also doesn't seem to support conditional format.You can check the results below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi KG_90 ,
I tried my best with this visual object not so good customization features and it also doesn't seem to support conditional format.You can check the results below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
thanks Anonymous This should solve my problem!
- amitchandak
Super User
KG_90 , If are using a value column, it will aggregate
Thanks, should I then write a DAX formula to overrule it or is there a better way?
Hi KG_90 ,
First you can right click on the field and select don't summarize or select average. If there are other conditions you can write a simple AVERAGE expression to use with conditional formatting and you can share a sample if you have any questions. We will help you better.
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Anonymous,
I think I should have been more precise:
The values I'm using are already calculated as an average of "Score" - I removed data aggregation but it still doesn't work.
Below a sample out of my dataset:
Country Product Owner Category1 Category2 Category3 Score ABC XY Data
a Z 2 ABC XY Data a Z 2 ABC XY Data a Z 1 ABC XY Data b Z 2 ABC XY Data b Z 1 ABC XY Data a X 4 ABC XY Data a X 3 ABC XY Data b X 1 ABC XY Data b X 2 Sunburst should show the data in the following way:
center - product owner
first ring - category 1
second ring - category 2
third ring - category 3
I also need to be able to filter by country and that's why I can't use static colours so I'm using a Sunburst by PowerViz and even if I select the data not to aggregate (sum) data, it still does.
My final output (at least for now) has 6 countries, 4 category1, 12 category 2, 27 category 3.
