- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Yes/No condition formatting
I have this dataset with yes and no in one column and attributes in another column now if I select yes, the related value in the attribute column will show, and if we choose No, then all the values will appear.
kindly help me out !!!!
attribute | yes/no |
A | YES |
B | YES |
C | NO |
D | NO |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Take a slicer in drag that yes/no column into it. Then in a table visual drag attributes measure. It has to be written as below:
Attributes = If(SelectedValue(Yes/No)="Yes",Values(Attributes),Calculate(Values(Attribute),All(Table)))
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It's not very clear what you're trying to accomplish.
Do you want to include a slicer in a Page that behaves like this?
If yes, you'll find this post useful:
https://community.powerbi.com/t5/Desktop/Filter-include-all-data-column-yes-no/m-p/945654
Hope this helps.

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
02-09-2025 02:16 AM | |||
06-06-2025 06:12 AM | |||
04-25-2025 10:47 AM | |||
05-20-2025 08:00 PM | |||
10-30-2024 02:44 AM |
User | Count |
---|---|
67 | |
57 | |
50 | |
36 | |
34 |
User | Count |
---|---|
84 | |
74 | |
56 | |
45 | |
44 |