topic Re: Bakgrund and number colors!! in DAX Commands and Tips

Bakgrund and number colors!!

Bergh — Thu, 21 Apr 2022 10:21:16 GMT

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

Re: Bakgrund and number colors!!

tamerj1 — Thu, 21 Apr 2022 10:32:13 GMT

Bergh

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

Re: Bakgrund and number colors!!

amitchandak — Thu, 21 Apr 2022 10:31:13 GMT

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

Re: Bakgrund and number colors!!

Anonymous — Wed, 27 Apr 2022 08:05:19 GMT

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-by-rules

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-based-on-a-calculation

Best Regards,

Jay