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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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