Forum Discussion
Conditional formatting background color with column containing both text and numeric values
No measure needed.
Step 1. Unpivot the Sample Data so that you can create a 'Rank' column that will have your assigned number rating.
Step 2. Copy table above / create / insert a table that follows the columns I have used above.
Step 3. Create a relationship between newly created table and then your Sample Data table using 'Rank' as a link.
Step 4. On your Matrix visual, go to the conditional formatting area and create a Rule based on the 'Colour Label' field from the new table you created. For example If Colour Label value = 1 (Green), If Colour Label value > 3 (Blue), If Colour Label value = 3 (Red).
Should all be working. No measure needed, just a new table to make this relationship between 'N/A' and a numeric value.
Is there some formula i can use to create a measure such that i can hold those values in the table itself and after it is unpivoted . i have seen a question in the community on using switch but not sure on the implementation . do you have an idea in this regard ?
Result of the above suggestion.
If you wanted to keep the N/A too you could just use another column which has N/A value still in it but still link through the Rank column.
Well this is a new perspective and thanks for giving me an idea this way .
However i have created a new column with the formulacolorvalue = switch("Column name ","n/a",6,"4",4,.......) this created a new col in the table and i have formatted using this newly created column.
Thanks
Jagadeesh