Bakgrund and number colors!!

[Bergh]

Hello. If I have a table with 10 columns and in each of these columns there are the numbers 1 to 6. If I now wanted to change the background color and the numbers to the colors you see in the picture. How to do it easiest?
Thanks

[Anonymous]

Hi @Bergh ,

You will need to set conditional formatting for each column.

You could manually set conditional formatting Rule to return different colors depend on the column values.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-... 

Or you could create a measure like amitchandak showed above and use it as conditional formatting Value.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-... 

Best Regards,

Jay

[amitchandak · Accepted solution]

@Bergh , Create a measure like

Switch(Max(Table[Column]) ,  // or Sum(Table[Column])

1, "#FAFAFA" ,

// Add other condition

)

Use this measure in conditional formatting using the field value option.

If you need to do it for each column value, you need that many measures

How to do conditional formatting by measure and apply it to pie? : https://youtu.be/RqBb5eBf_I4

[tamerj1]

@Bergh 

The way I know need to do measure by measure unless this visual is a matrix that contains only one measure