How to When no selection in Slicer, show nothing

[lardo5150]

In my table I have a slicer to pick which day to show data.

of course if i dont select anything it shows them all.

This is going to build so this is not ideal.

How can I set the slicer, so that when nothing is selected, it does not show the day columns, but still shows the engineer column?

[lardo5150]

@Jihwan_Kim that did not work for me sorry.

I got closer with this:

dayselection2 = IF(ISBLANK(SELECTEDVALUE(crb3f_totalcases[crb3f_date])),0,1)

When nothing is selected, nothing shows.

The only problem here is I am still wanting the full list of engineers to show, and it is not doing that.

So the idea is when nothing in the Date slicer is selected, the only column that should show up is the full list of engineers.

Now, using what I have above, if I choose 1 item in the slicer, I get 1 item.

but if I select two or all, nothing shows up.

What i am expecting to happen is this:

1. If nothing in the slicer is selected, the only column that should show up is the list of engineers on the left.

2. if I select something int he slicer, it shows that column, if I select another, that column, etc.

I even tried taking the slicer out and just adding that as a filter for the table, same thing:

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope you can apply the similar concept to your data model.

Please be noted that the column used for slicer visual is not the same column as that is used in the matrix visual.

Value total: =
SWITCH (
    TRUE (),
    ISFILTERED ( 'Calendar'[Date] ), SUM ( Data[Value] ),
    BLANK ()
)

[mh2587]

You can HASONFILTER() OR HASONVALUE() function on date column to acheive this

[lardo5150]

How would you set the HASONFILTER?