Forum Discussion
Conditional formatting background color with column containing both text and numeric values
i have a matrix visual which displays info about a employees skills * Java * C# * Customer Service * Punctuality * Technical strength the above are ranked from 1-3 with 1 being bad (red col...
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