different background color for each value

[powerbiexpert22]

i want to add column in below table which should show different background color for each priorty . example it should show  green background for 0, orange for 1 and red for 2, the column should not show any data

[Angith_Nair · Accepted solution]

Hi @powerbiexpert22 

Create a measure that will display the priority. Apply background conditional formatting for this measure something like the below dax:

PriorityColor = 
SWITCH(
    TRUE(),
    TableName[Priority] = 0, "Green",
    TableName[Priority] = 1, "Orange",
    TableName[Priority] = 2, "Red",
    BLANK()
)

To ensure the column does not display any values make sure to format the text color to match the background color (via Conditional Formatting for text). Alternatively, make the font color transparent or very light so it blends with the table.

[Bibiano_Geraldo · Accepted solution]

Hi @powerbiexpert22,

Add a measure using the following DAX 

Priority Color = BLANK()

Now drag and drop the color measure to your Matrix, and add a conditional format as shown bellow:

Now configure the prompt screen to something like this and hit ok:

Now your table, should look like this:

I hope this was heplful, if yes please accept as solution and give a kudo.

Thank you

[Bibiano_Geraldo · Accepted solution]

Hi @powerbiexpert22,

Add a measure using the following DAX 

Priority Color = BLANK()

Now drag and drop the color measure to your Matrix, and add a conditional format as shown bellow:

Now configure the prompt screen to something like this and hit ok:

Now your table, should look like this:

I hope this was heplful, if yes please accept as solution and give a kudo.

Thank you

[Kedar_Pande]

@powerbiexpert22 

Create a new calculated column to hold blank values (it will serve as the placeholder for formatting):

BlankColumn = BLANK()

Create a measure to define the color logic for each priority:

PriorityColor = 
SWITCH(
TRUE(),
'YourTable'[Priority] = 0, "#00FF00", 
'YourTable'[Priority] = 1, "#FFA500", 
'YourTable'[Priority] = 2, "#FF0000", 
"#FFFFFF" -- Default to white
)

In the Conditional Formatting settings for BlankColumn, select the PriorityColor measure as the field for background color.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[ajohnso2]

Hey,

You can create a measure to control the different colours and use that measure for conditional formatting.

Priority Colour =

VAR _Priority = MAX('Priority'[priority])

RETURN

SWITCH(

    TRUE(),

    _Priority = 0, "Green",

    _Priority = 1, "Orange",

    _Priority = 2, "Red"

)

[powerbiexpert22]

Hi @ajohnso2 , @Angith_Nair 

thanks, is there a way to show custom color like below in column

[ajohnso2 · Accepted solution]

Yes you can use any colour you like...

RGB Color Codes Chart 🎨

Replace "Orange" with the hex colour code of your liking. e.g. "#FFFFFF"

[Angith_Nair · Accepted solution]

Hi @powerbiexpert22 

Create a measure that will display the priority. Apply background conditional formatting for this measure something like the below dax:

PriorityColor = 
SWITCH(
    TRUE(),
    TableName[Priority] = 0, "Green",
    TableName[Priority] = 1, "Orange",
    TableName[Priority] = 2, "Red",
    BLANK()
)

To ensure the column does not display any values make sure to format the text color to match the background color (via Conditional Formatting for text). Alternatively, make the font color transparent or very light so it blends with the table.