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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
IGunn
Frequent Visitor

Change Yes No Filter to Yes or All

I have a field in my dataset that identifies if a project is owned (Yes) by the user or Not owned (No). No means they have an interest in the project.
In the filter I want the user to be able to select All projects or just Yes to return just the ones they own.
Is this possible to remove the No option?

1 ACCEPTED SOLUTION

Thankyou for the quick repy Amitchandak, I did not us e this solution as I could not this measure into Filter Slicer. What I found that worked was adding my field as a Filter and then in the Advanced Filtering , Show Items when value IS NOT "No"

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@IGunn , You can control the slicer/Visual using visual-level filter.

Or you can use measure like

 

countrows(filter(Table, Table[Owner] = "Yes") )

 

Ignore no filter

 

countrows(filter(all(Table[Owner]) , Table[Owner] = "Yes") )

Thankyou for the quick repy Amitchandak, I did not us e this solution as I could not this measure into Filter Slicer. What I found that worked was adding my field as a Filter and then in the Advanced Filtering , Show Items when value IS NOT "No"

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.