Isfiltered + Or + and for multiple slicer in a measure

[NourJ]

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...

[Lakshi]

Isfiltered + Or + and for multiple slicer in a measure

‎06-20-2019 06:19 AM

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...

Can anyone help with the formula here? 

Check filtered Industry Sgement = CALCULATE(ISFILTERED('Sector Info'[Industry]))

Hide visual (Industry Segment) = IF([Check filtered Industry Sgement],1,0)

Message (Industry Segment) = IF([Check filtered Industry Sgement],"","Please select an Industry Segment")

Transparency (Industry Segment) = IF([Check filtered Industry Sgement],

"#FFFFFF00",

"white")

Righit now the data is getting filtered using just one filter (Primary Sector) but i want to add "OR" option in this filter so that data is reflected if when we select company or industry. 

[v-shex-msft · Accepted solution]

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