Heat Map

[Anonymous]

Hello team, I need Hep with this

I have this type of visual in  dashboard...I need to create a heat map for this Visual..
I kno the procedure to create a condition Formating...
Can you Suggest me the Colour Codes For this Visual
like this

[Anonymous · Accepted solution]

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.