Forum Discussion
Measure or Conditional formatting?
Hi Anonymous ,
I tried to use measure to solve your problem, since there is no option for conditional formatting for Rows in the matrix, I tried to make a color change to value, trying to achieve the same result, I was traversing it with COUNTAX, calculating whether it is unitary or not under the level of each of your SKU's, then assigning the color, and then finally using this measure in the formatting condition.
Measure = VAR A= COUNTAX( FILTER(ALL('Table'), 'Table'[SKU]=MAX('Table'[SKU])), 'Table'[Value]) RETURN IF( A>1, "Red", "Green")I hope my thoughts have solved your problem, if you have any further questions, you can always contact me and I will get back to you as soon as I get the message!
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous ,
Please try the below steps , i have created 2 calculated columns and then mapped the same to have the conditional formatting in Table visual.
1, Calculated col 1
2.Calculated Col 2
Step 3 - add the same to the conditional formatting
If you find this helpful , please mark it as solution and Your Kudos/Likes are much appreciated!
Thank You
Dharmendar S
Hey! Thanks for the tip! Although this is not working for the matrix visualization unless I miss something... My view is already created from a different table and what I have presented is a "matrix" view in PowerBI.
I can't do this calculation as my table has different structure.
Any other ideas?
Hi Anonymous ,
I tried to use measure to solve your problem, since there is no option for conditional formatting for Rows in the matrix, I tried to make a color change to value, trying to achieve the same result, I was traversing it with COUNTAX, calculating whether it is unitary or not under the level of each of your SKU's, then assigning the color, and then finally using this measure in the formatting condition.
Measure = VAR A= COUNTAX( FILTER(ALL('Table'), 'Table'[SKU]=MAX('Table'[SKU])), 'Table'[Value]) RETURN IF( A>1, "Red", "Green")I hope my thoughts have solved your problem, if you have any further questions, you can always contact me and I will get back to you as soon as I get the message!
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.