Dax color formatting

Question

Hello folks,&nbsp;For a worldoverview I´m using the Global Launch Estimates map.I needed an overview of the countries by color.&nbsp;However, I want to add a column with the code of a specific color based on a value, see my example below:&nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ColorNew York&nbsp; &nbsp; &nbsp; &nbsp; 1.001&nbsp; &nbsp; &nbsp; &nbsp; Dax formula with Hex # codes from red to green based on valueParis&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 900&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dax formula with Hex # codes from red to green based on valueDublin&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;665&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Dax formula with Hex # codes from red to green based on valueLondon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.178&nbsp; &nbsp; &nbsp; &nbsp;Dax formula with Hex # codes from red to green based on valueBarcelona&nbsp; &nbsp; &nbsp; &nbsp;1.980&nbsp; &nbsp; &nbsp; &nbsp;Dax formula with Hex # codes from red to green based on valueMadrid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.095&nbsp; &nbsp; &nbsp;&nbsp;Dax formula with Hex # codes from red to green based on valueAmsterdam&nbsp; &nbsp; &nbsp;300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dax formula with Hex # codes from red to green based on value&nbsp;The codes needs to be based on the value and not on the name of the city.&nbsp;Cheers!

fsciencetech · Accepted Answer

Create measure for the color like below and use this measure in your value&nbsp;Color = IF(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;value&gt;0,&nbsp; &nbsp; &nbsp; &nbsp;"#F40606",&nbsp;"#252423")&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Dax color formatting

2 Replies

Related content

Conditional Formatting using DAX

DAX Formatting - Money

Color in Dax

Format number color with dax

Conditional formating using DAX