Dynamic Pie Chart Based on Slicer

[kkmarlin]

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.*****

[amitchandak · Accepted solution]

@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