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 spend. Another Pie chart shows the Top 10 Part Numbers overall (not specific to any Customer).

 

Goal.....

If a specific Customer is selected, I would like the pie chart to change to show the 'Top 10 Parts' for that customer based on spend.

 

****If this cannot be done easily with the desktop tools but is possible either with DAX code or a customer visual, please let me know and I will move this to the Developer Help Forum.*****

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

     

     

1 Reply

  • 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