Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Pankjvrji
New Member

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

 

attributeyes/no
AYES 
BYES 
CNO
DNO
2 REPLIES 2
Kishore_KVN
Super User
Super User

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
Resolver II
Resolver II

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

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!