Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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"
@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"
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |