Diverging colors background based on measure

[breuwer]

Hi all, 

First time questioner, but I have already used this community for so many questions so thanks for that! 🙂

My question, I would like to write a DAX measure that has diverging colors (like in the settings below) as an output in order to use "format by field value" instead of "format by color scale". 

I would like this since I have to implement these backgrounds for many visuals in my report. 

Requirements: 

Lowest value is color #EE4B2B
Midpoint is a fixed number: 100 and is color #FFFFFF

Highest value is color #00A36C
The measurement difining the value is a simple sales index, let's call it [Sales Index].

Any pointers are much apreciated!

Kind regards, 

Bas

[v-easonf-msft · Accepted solution]

Hi,  @breuwer 

What you need is hard to achieve in powerbi. If you want to format by field value, then you inevitably have to mark a color for each unique value.、

I'm afraid that currently you can only manually set the background conditional formatting one by one.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@breuwer , filed value can have absolute colors.

Unless you have some logic to create diverging colors

mean based on number you can calculate some number