Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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?
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
Thanks. I edited the question just to be more specific. Please look at that and let me know.
HI @ravalib,
Can you please share the pbix file for test?
Regards,
Xiaoxin Sheng
Sorry, it is confidential data and it is coming from a DB. Not allowed to do so.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |