Creating Sunburts

[acg]

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?

[serpiva64]

Hi,

i don't know if it is possible

i obtained this if it is worth

[AllisonKennedy · Accepted solution]

@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]

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. 

[amitchandak]

@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