Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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"
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
111 | |
104 | |
85 | |
65 | |
63 |