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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors