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 |