Forum Discussion
Average in sunburst chart
Hi Giten ,
Please create a new measure.
Subcategory_Avg_Sales =
AVERAGEX(
SUMMARIZE(
'Table',
'Table'[Category],
'Table'[Subcategory],
"AverageSales",
AVERAGE('Table'[Sales])
),
[AverageSales]
)Please check if this is the output you are expecting。
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Lucy Chen,
Thanks! The table shows the right average (also for Category1 and Category2). However, if I put it in a sunburst, the subcategories and categories are still summed up. I guess that's what ryan_mayu meant.
P.S. I'm new here, how do I attach a pbix?
Hi Giten ,
Thank you for your kind reply!
I apologize for using the wrong visualization.
I made a lot of attempts. It's true that he can't calculate the average of the previous level (Sunburst), but I found another visualization.
Although he still can't show the averages of the categories, we can view the averages of the different categories in a table.
In addition, you need to be a super user to attach files on messages.
The other option is to put your files in a dropbox, onedrive or googledrive folder and share the link with the community.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for all the effort, this helps a bit. Still, I'm looking for averages in the sunburst itself, but maybe that's just not possible. I'll keep looking.
Hi Giten ,
Thank you for your kind reply!
The same goes for us, I will contact you if there is any follow up, and if you find a solution to the problem, please share it here as well, it will help more people!
Thank you for your understanding!
Best regards,
Lucy Chen