Issue with Conditional Formatting

[sonam7]

Hi,

I am trying to do conditional formatting on Text Field but I see that there is no direct approach to do that. Hence, I have come across a work around to achieve the same. Please find below the DAX code I have written for the color coding:

StateNumber =

VAR StateValue = SELECTEDVALUE('MASCI vwEnvironments'[State])

RETURN

SWITCH(TRUE(),

StateValue = "In Progress", 1

)

Basically, I am trying to color-code based on State. However, the conditional formatting doesn't work fine.

As you can see below, it skips some of the values which are in State: "In Progress" . Also, sometimes it introduces duplicates of rows but that goes away when I refresh.

Please help with the same!

[Anonymous · Accepted solution]

Hi @sonam7 

Check in the original dataset, if you have duplicates.

If there are duplicates, the formatting will not show.

You will have to get rid of the duplications. That can be achieved with adding a unique ID/Index to your visual, or deleting the duplicates in the import process.

Thanks!
A

[gckcmc]

is it possible that in the rows that are being skipped over there is extra white space after "progress" like "In Progress "?