Help with Heat Map

[puneethjp]

Hi,

I am currently working on requirement where we need a Heat Map. I am currently using Table Heat Map 3.5.0 ( Custom Visual)

1. Firstly,  COuld you please recomend any other Table heat map if any. (no license). 

2. As per the image below(image-1),  I am unable to round the values to round 2 decimals. (Note: I tried to round the values by selecting the measures and format to 2 decimal in format tab. The result still appears to not turn the values to 2 decimal. 

3.  I would like to turn the current heat map as below(Image-2). For some reason it is not even allowing me to change the colors too. (Image-2). Tried options like Colorbrewer. It only has custom colors and it does not allow me to select any colors as we wanted as per image -2. 

Image- 1

Image - 2 (expected output)

Would really appreciate your time and help. 

Thanks and Regards

Puneeth

[PhilipTreacy]

Hi @puneethjp 

Please supply your data/file - imposible to really help without it.

Regarding rounding to 2 decimal places.  You'll need to use the DAX ROUND function ROUND function (DAX) - DAX | Microsoft Learn for this.

When you set the format to 2 decimal places, all you are doing are changing how it is displayed, you are not actually changing the value.

regards

Phil

[puneethjp]

Formating to 2 decimal worked though. Thannk you though... 

Please see data below @PhilipTreacy  Please let me know if you need anything else. 

Promo Price	$ Lift Comp	week_ending_date	Unit Lift
2.33	0.11	09-01-2021 00:00	0.21
2.26	0.12	16-01-2021 00:00	0.25
2.38	0.11	23-01-2021 00:00	0.22
2.38	0.1	30-01-2021 00:00	0.22
2.53	0.11	06-02-2021 00:00	0.17
2.46	0.12	13-02-2021 00:00	0.17
2.33	0.12	20-02-2021 00:00	0.22
2.29	0.13	27-02-2021 00:00	0.21
2.44	0.12	06-03-2021 00:00	0.17
2.32	0.12	13-03-2021 00:00	0.21
2.2	0.12	20-03-2021 00:00	0.26
2.38	0.14	27-03-2021 00:00	0.24
2.4	0.15	03-04-2021 00:00	0.27