Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
dancingthrough
New Member

Dynamic piechart based on data in single table

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?

 

dancingthrough_0-1722378793763.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

vjialongymsft_0-1722389380294.png

vjialongymsft_1-1722389400481.png


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.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

vjialongymsft_0-1722389380294.png

vjialongymsft_1-1722389400481.png


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.

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.