Donut Chart from multiply column

[Delion]

Hi How to create donut chart from multiply column like above,  without doing transpose / pivot on the original table structure ?

Thank

[v-robertq-msft · Accepted solution]

Hi, @Delion 

According to your requirement, I think you can just place the multiply columns into the “Value” of the Donut chart and set the summarize type like this:

What’s more, you can also create a slicer to slice the data based on sales like this:

And you can get what you want.

You can download my test pbix file here

More info about “Create and use doughnut charts in Power BI”

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Delion]

Yes Thank you 🙂

[HarishKM]

@Delion  Hey ,
you can create a reference Table in power pivot then unpivot the all col rest date .
you will 3 col then 1st date 2nd Attribute and 3rd Value .
simple then select Donut chart in PBI desktop then drag Attribute and value .

Bingo! 
you have your donut chart .

[amitchandak]

@Delion , If you want multiple measures in donut then you can not have legend (seem like the date is a legend here)

If you want to replace columns in the donut, You need to explore bookmarks and button

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive