Show blank if nothing is selected in the slicer

[abn00122]

Hi All, 

I hope you can help me with this problem. I am try to only display the rows in the table visual if there is a date selected in the slicer. The slicer is a Date, while the table visual only have columns of Category and Count of Product.

Thank you!

[Idrissshatila]

Hello @abn00122 ,

@AnkitaaMishra  approach is correct, but if the region column is in the table then it won't hid because it would be taking the filter from the column in the table, then the dax should be modified.

[abn00122]

Hello! Thank you for pointing this out. Will you be able to show how to fix this, please? Thank you!

[Idrissshatila · Accepted solution]

Hello @abn00122 ,

use this measure

Filterselected =

IF(

    CALCULATE(ISFILTERED(sampledata[Region]),ALLSELECTED(sampledata[Region])),

    1,

    0

)

[AnkitaaMishra]

Hi @abn00122 , Hope you are doing well.

Please create a measure with below DAX (Please modify the dax as per your date column) : 

Filterselected =

IF(

    ISFILTERED(sampledata[Region]),

    1,

    0

)

Use above measure to filter for your table visual and set it to 1 as shown below : 

the output will be : 
when you select something on Region filter then the table will show respective data else it will show blank table : 

Let me know if this works for you or give additional details about your requirement.
Thanks,

Ankita