Forum Discussion
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 also makes the graph blank.
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.
7 Replies
poweruser55 , Not very clear, with empty filter or blank filter, it should not show any data. Or should only available data with that value
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. @
Hi poweruser55
Usually, if you don't select the value in slicer, then it will show all data, and if you choose one has no data in it, it won't show data(see below). So could you provide more details for us to check?
Usually we need information below
(1) a sample file, you can replace raw data with bogus data to protect your privacy.
or provide some sample data that fully covers your issue/question.
(2) give your expected result based on the sample you provide.
Thanks.
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.
The visual has data in it which is the problem. I want the graph line to only become blank when the value in the filter is selected. v-xiaotang There is a graph that changes based on
I want the solid purple line to dissapear when lets call it filter "A" is selected. Right now when filter A is selected the line is still there and it changes, but I don't want it to do that I want the line to be invisible when filter A is selected. v-xiaotang
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.
