Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
NourJ
Helper III
Helper III

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
v-shex-msft
Community Support
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
Lakshi
Frequent Visitor

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
Community Support
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.