How do I get a Card to show no data when no option is selected in a filter slicer?

[Amarnay]

How do I get a Card to show no data when no option is selected in a filter slicer?

[Anonymous · Accepted solution]

Hi @Amarnay ,

I made simple samples and you can check the results below:

Please feel free to correct me and provide more information if I have misunderstood you!

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[lbendlin]

ISFILTERED works on the data model, not on a visual 

[Amarnay]

ISFILTERED() only works on a table. I am looking for a Card

[Daniel29195]

Hello @Amarnay

you can use something like this : 

if we assume you have country as a slicer , and customrename as a second slicer you can use the following measure : 

 measure = 

switch(

true(), 

isfiltered ( table_name[country] ) || isfiltered( table_name[customername]) ,  sum(sales) ,

blank() ) 

)

the logic is to check with isfiltered if you have any filters in the filter context.

now the problem with this approach, that everytime you add a slicer, you need to go and modify your measure to take the new slicer into consideration ,

so another approach i would suggest (  if your slicers are gettings the data from dimensions and you have a fact table in the middle) , 

so you can use this dax code  : 

measure = 

switch(

true(), 

iscrossfiltered ( facttable_name )  ,  sum(sales) ,

blank() ) 

)

hope this helps you out.

best regards

ressources : 
https://dax.guide/iscrossfiltered/

https://dax.guide/isfiltered/

[lbendlin]

Consider using ISFILTERED(). Note that this will also return FALSE when everything is selected.