Forum Discussion
Conditional format a matrix to highlight differences within same row
Objective - highlight the differences between products on a row by row basis So, in this simple example, I select a few 'recipes' from a slicer, which adds a few columns to the matrix. On each ...
Hi jpc ,
Below is my table:
The following Dax might work for you:
Column =
var _app5 = LEN('Table'[Description])
RETURN
SWITCH(
TRUE(),
_app5 <= 5 , 1 ,
_app5 <10 && _app5 > 5 , 2,
_app5 < 15 && _app5 >10 , 3
)The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for taking the time to read my question, and build a solution.
Unfortunately, i still see in your example that Apple and Peach are still the same colour. Length of the string is not an effective method, i am looking to improve on this with some string comparison, if you have any ideas on this?
