Slicer with Multiple Dynamic Pie Charts

[fleuhusen]

Hello everyone!

Thank you for taking the time to help. I've been looking through the forums but have had a hard time finding any solution. I'm trying to have a slicer that dynamically controls the values of pie charts. I don't want the pie charts to show the total amount, but rather show individually data for each year.

Below is an image of what I'm trying to do, and I have the red text below showing what I want the output to be in the charts.

Do you have any ideas about how I can accomplish this with the slicer, or another slicer, so that each one of the pie charts will show data on a year by year basis related to the slider. In the example above it shows 2017 - 2019, but if I change the slider to 2016-2018, then I want the three charts to update to show those years instead.

It would also be interesting to find out if there is a function with the slicer that always restricts the values to 3 years in this case, as otherwise I can only imagine that there will be errors if more/less years are choosen.

Thank you for your insight and I appreciate your expertise.

Best regards,
Fredrik

[amitchandak · Accepted solution]

@fleuhusen , As of now small mutiple is not supported on pie visual. This would be an easy go.

You can log an idea for that.

Not you might create measures based on max year for last three years, three different visuals. but that would be static

example

This Year = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

Last to last Year = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year])-2))

Also, check some custom visuals if that can support this.

[fleuhusen]

Thank you @amitchandak! I'll log an idea for it and we'll see if it moves forward anytime soon. Your code is helpful, but I feel that maybe the charts in that case would more easily be controlled with a filter if the code makes the values static.