Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filtering a bar chart by y-axis value

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?

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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