Forum Discussion

kkmarlin's avatar
kkmarlin
New Member
4 years ago
Solved

Dynamic Pie Chart Based on Slicer

Hello,   I am trying to create a Pie chart that changes when a value in a slicer chart is selected.    So far..... If no Customer is selected, the pie chart shows the top 10 Customers based on s...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    kkmarlin , if you want to change the axis or legend, you need bookmarks. so based on if no customer is selected is really difficult as you want product as legend in place of customer

     

    Axis Slicer
    Three approch from Guyinacube https://www.youtube.com/watch?v=dYmzb5UMkXw
    Dynamically change chart axis in Power BI
    bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/

     

    You can button select customer, that can help in implementing bookmarks

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

kkmarlin , if you want to change the axis or legend, you need bookmarks. so based on if no customer is selected is really difficult as you want product as legend in place of customer

 

Axis Slicer
Three approch from Guyinacube https://www.youtube.com/watch?v=dYmzb5UMkXw
Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/

 

You can button select customer, that can help in implementing bookmarks