Forum Discussion
Creating Sunburts
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 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.
