cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NourJ Regular Visitor
Regular Visitor

Isfiltered + Or + and for multiple slicer in a measure

Hi all,

 

I am trying to hide a visual until specific slicers/filters to be used,

so after searching, I am doing this by a measure which says if nothing selected then white color, if the filter ... is selected then turn the color transparent, to show what is hidden underneath. (if there is another way please refer it to me)

here is my measure:

Make Transparent = IF(ISFILTERED(Locations[Nahya]),"#FFFFFF00","White")
basically, it works well with one slicer which is after ISFILTERED, but I didn't success to make it active if multiple slicers selected, because I have three specific slicers I want to put them as a condition with AND or OR, so if one of them selected or, all, or only two...
 
 
 
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Isfiltered + Or + and for multiple slicer in a measure

Hi @NourJ ,

Can you please share some sample data with expected result for test? It will be help for coding formula.
In addition, you can take a look at following link about all allexcept function to ignore other filters.

Using ALLEXCEPT versus ALL and VALUES

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: Isfiltered + Or + and for multiple slicer in a measure

Hi @NourJ ,

Can you please share some sample data with expected result for test? It will be help for coding formula.
In addition, you can take a look at following link about all allexcept function to ignore other filters.

Using ALLEXCEPT versus ALL and VALUES

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |