Forum Discussion
Solved
Creating Sunburts
I like to create a smiple sunburts in PowerBI like it is possible in xls: 2020 2019 one Area 2 1 two Areas 1 4 three Areas 1 2 more than three 1 0 total n 5 7 ...
acg You need to unpivot your raw data first.
In Power Query (click Transform Data in the Home tab in Power BI to open Power Query), select the 'Year' column and in the Transform tab click 'Unpivot OTHER columns'
Then Close and apply changes.
Put [Year] in Category, [Attribute] in SubCategory, and [Value] in Measure.
acg , based on what I got. I think you need to unpivot the table. Both Area and Year on rows. That can be used as a category and sub-category