Forum Discussion
Help with Heat Map
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
2 Replies
- PhilipTreacySuper User
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
- puneethjpHelper II
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