Forum Discussion
Pankjvrji
3 years agoNew 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 w...
Kishore_KVN
Solution Sage
3 years agoTake 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!!