Filtering a bar chart by y-axis value

[Anonymous]

I have a Clusted column chart as shown, but I wanted to be able to filter to only one y axis value at a time using a slicer selection. I cannot use a slicer because all three values on the chart are calculated measures. Is it possible to do this?

[amitchandak]

@Anonymous , You need to have what-if parameter and based on that you can filter

You can have a measure like this or you can use this in visual lebel filter

measure =

var _max = minx(allselected(whatif), whatif[value])
var _min = maxx(allselected(whatif), whatif[value])

return

sumx(filter(Summarize(Fact, fact[Axis Col], Fact[Legend Col]) , [Measure] >=_min && [Measure] <= _max) , [Measure])

https://docs.microsoft.com/en-us/power-bi/desktop-what-if