Forum Discussion
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 |
I inserted the above data in Power BI like this
I imported the Sunburst by MAQ Software, but have problems in understanding how to create this with the above data:
Is it possible to create the same chart like with xls?
I don't understand how I need to change the data input above and what the measure is going to be?
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.
4 Replies
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
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.
Excellent AllisonKennedy I will have a look how to be able to change individual colours of the different areas. But thina you so much to get me here.
Hi,
i don't know if it is possible
i obtained this if it is worth
