- 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
Subject | Author | Posted | |
---|---|---|---|
02-09-2025 02:16 AM | |||
04-25-2025 10:47 AM | |||
06-06-2025 06:12 AM | |||
03-27-2025 04:17 AM | |||
10-30-2024 02:44 AM |
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |