Forum Discussion
Conditional formatting background color with column containing both text and numeric values
Hey can you provide me with the measure we can use to assign values and put those values in a new column as you have suggested above. Thanks.
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 ?