HASONEFILTER or ISFILTERED not working for Timeline Slicer and Map

[ravalib]

Hi guys,

I am trying to use hasonefilter/isfiltered on a timeline slicer which is on year level. What I want to do is, unless I make a year selection on the timeline slicer,  I want a particular bar graph to be empty. So I use a measure - if(hasonefilter(table[column_name],1,2) and set the measure to 1 under visual level filters. But this seems to work for everything else except the timeline slicer and the Map. Please let me know how i can get it to work for these two. 

Note: the column in the hasonefilter is date column which has date in the format mm-dd-yyyy. I believe this is the cause of the issue. Any help?

[Anonymous]

Hi @ravalib,

I'd like to suggest you to use HASONEVALUE function to instead:

flag = IF(HASONEVALUE(Silcer[Type]),1,2) 

>>Also, if I multi-select the slicer after adding the above DAX, it is not working.

Since hasonevalue not works on multi-select, I modify the formula to use other condition to check if the slicer has been selected.

flag =
IF ( COUNTROWS ( Slicer ) <> COUNTROWS ( ALL ( Slicer ) ), 1, 2 )

Notice: since power bi can't correct recognize 'all select' and 'unselect', it not works when you select all items on slicer.

Regards,

Xiaoxin Sheng

[ravalib]

 Thanks a lot for your reply.

I also asked about how if we have multiple slicers (more than 1), how will we make sure that the visual goes blank unless a selection is made in any of these slicers? I basically want the same thing to happen.. except with more than 1 slicer.. can u please suggest?

[Anonymous]

HI @ravalib,

>>I also asked about how if we have multiple slicers (more than 1), how will we make sure that the visual goes blank unless a selection is made in any of these slicers? I basically want the same thing to happen.. except with more than 1 slicer.

For your requirement, you can duplicate bold part formula with needed slicer source table as conditions.(use 'AND' logic link them)

flag =
IF ( COUNTROWS ( Slicer ) <> COUNTROWS ( ALL ( Slicer ) ), 1, 2 )

Sample:

flag =
IF (
    COUNTROWS ( Table1 ) <> COUNTROWS ( ALL ( Table1 ) )
        && COUNTROWS ( Table2 ) <> COUNTROWS ( ALL ( Table2 ) ),
    1,
    2
)

Regards,

Xiaoxin Sheng

[ravalib]

Thanks. I edited the question just to be more specific. Please look at that and let me know.

[Anonymous]

HI @ravalib,

Can you please share the pbix file for test?

Regards,

Xiaoxin Sheng

[ravalib]

Sorry, it is confidential data and it is coming from a DB. Not allowed to do so.

[pallavishrivas]

hi @ravalib,

Did you find any solution for this issue.

Thanks

Pallavi