Heat Map

Hi Anonymous ,

 

As for the color codes, you can use the following DAX code to assign colors based on the values of your measure:

Measure Value Color = 
SWITCH (
    TRUE (),
    [Measure Value] <= 1, "#000000",
    [Measure Value] < 99.5, "#e60000",
    [Measure Value] < 100.5, "#000000",
    [Measure Value] < 999999, "#2d862d",
    "#000000"
)

This code assigns colors to the measure values based on the conditions specified in the SWITCH function. You can modify the color codes and conditions as per your requirements.

 

If you wish to set the gradient color, you can select the format style of [Gradient]. Or you can choose to custom  visual.

Please refer to the following documents for more information.

Changing colours using DAX and conditional formatting in Power BI - Data Bear - Power BI Training and Consulting

How to Create a Power BI Heatmap | DataCamp

Creating a Table Heatmap in Power BI - Power BI Docs

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.