Forum Discussion
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 |
2 Replies
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.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!!
