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 ...
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
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
