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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.