Reply
Pankjvrji
New Member
Partially syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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.

 

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)