Forum Discussion
Conditional Formatting with multiple columns
Hi all, I've got a 3 tables which looks enquiries/sales/% conversion - First being Organisation Level, second Franchise, third Shop. Each shop sits within the following grouping : "Premium","Speciali...
Hi Anonymous ,
You can change dax to this:
Condition = Switch( true(), Max('LookUP Final'[Brand])="Volume"&& [% Dealt New] >=0.35, 1, Max('LookUP Final'[Brand]="Volume"&& [% Dealt New] >=0.30 && [% Dealt New] <0.35,2, Max('LookUP Final'[Brand]="Volume"&& [% Dealt New] >=0 && [% Dealt New] <0.30,3))))If my answer is not what you need, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
You can change dax to this:
Condition =
Switch(
true(),
Max('LookUP Final'[Brand])="Volume"&& [% Dealt New] >=0.35, 1,
Max('LookUP Final'[Brand]="Volume"&& [% Dealt New] >=0.30 && [% Dealt New] <0.35,2,
Max('LookUP Final'[Brand]="Volume"&& [% Dealt New] >=0 && [% Dealt New] <0.30,3))))
If my answer is not what you need, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.