Background colour formatting.

[sthandiwe]

Hi All

I have a dashboard where I need the background of a cell to reflect a certain colour depending on the contents of it. The rules are as follows.

It works well mostly. But there are some times when it reflects the wrong colour as shown below, the top right "Not Approved" should be in red, not yellow:

Note:

0=Not Approved=Red
1=Approved=Green

2=Rejected=Yellow

[PaulDBrown]

@sthandiwe 

Let's assume you are using a measure for the Approval Status. You can create a measure for the conditional formatting like:

Condit. format =
SWITCH(TRUE(),

[Approval Status] = "Not Approved", 0,

Approval Status] = "Approved", 1,

2)

Now use this measure in the conditional formatting interface -select the measure in the "based on the field" option- 

[amitchandak]

@sthandiwe , need to check data for that. Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.

Can you create a color measure directly on values like in the given example and use that with the "Field Value" option(in place od rule

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.