Yes/No condition formatting

[Pankjvrji]

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

[Kishore_KVN]

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!!

[JoBI]

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.