Forum Discussion
Reading Value in Table When Showing Rows with Blanks
I have to do some custom coloring that cannot and trying to use conditional formatting, but I am not getting the results i was hoping for. I have tried many methods, but continue to get the same res...
Hi,
Instead of using Measure, what if you create a column in the table using switch logic. For Example
ColorCodes = SWITCH(TRUE(),
Table[Status] = "01-New", "#000000",
Table[Status] = "02-ReOpen", "#6DB6FF",
Table[Status] = "03-Revisit", "#FF0000",
Table[Status] = "04-Open", "#008000",
Table[Status] = "05-Reset", "#FFFF00",
Table[Status]="06-Return","#480091"
)
Then use conditional formating on Status column by chosing option "Field Value" in Format by, "First ColorCodes" in Based on field and "First" in Summarization.
Thanks for the suggestion Anonymous, however, that gave me the same result. I was only using the measure as a last attempt, as I tried a similar calculated column, but just did the conditional formatting based on a rule, rather than a value. I had originaly tried a seperate data table with the statuses and color as the two columns, when I first started to have this issue. It was only when I tried the measure that I was able to see why my conditional formatting was not working.
