Dynamic piechart based on data in single table

[dancingthrough]

Hello,

I'm trying to create a dynamic pie chart. An example of what I want it to do is in the image. It shows the StorageUsed (MB) values based on the SiteDefinition column. I want to be able to change from StorageUsed (MB) to, for example, HasTeams using a slicer and keep the SiteDefinition as the legend. Any ideas on how to go about this?

[Anonymous · Accepted solution]

Hi @dancingthrough 

You can create some visuals and save their visibility properties using bookmarks, which can then be used to switch between them,
then you need to hold down the "CTRL" key and click on the corresponding bookmark button to switch between them.

Pbix file attached.

Best Regards,

Jayleny

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