Forum Discussion

poweruser55's avatar
poweruser55
Helper IV
4 years ago
Solved

Make graph blank with empty filter

I have a graph and when a filter is selected that has blank data the graph still displays all. How can I make it so that the default is All but when a filter selection is chosen that is has no data a...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi poweruser55 

    you can try the measure like below, when I select "a", then test2 line will disappear.

    test2 = IF(SELECTEDVALUE('Filter'[Column1]) = "a",BLANK(),MIN('Table'[Column1])+2)

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

poweruser55 , Not very clear, with empty filter or blank filter, it should not show any data. Or should only available data with that value

  • poweruser55's avatar
    poweruser55
    Helper IV
    4 years ago

    amitchandak When the column is blank for a specific filter it still shows all the data. i have the filter defaulted to all and if one I choose has no data in it, it still shows all the data. I've noticed this behavior in other graphs too, the graph only changes if the filter selection has data. @