Forum Discussion

puneethjp's avatar
puneethjp
Helper II
2 years ago

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

  • 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's avatar
      puneethjp
      Helper 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 Compweek_ending_dateUnit Lift
      2.330.1109-01-2021 00:000.21
      2.260.1216-01-2021 00:000.25
      2.380.1123-01-2021 00:000.22
      2.380.130-01-2021 00:000.22
      2.530.1106-02-2021 00:000.17
      2.460.1213-02-2021 00:000.17
      2.330.1220-02-2021 00:000.22
      2.290.1327-02-2021 00:000.21
      2.440.1206-03-2021 00:000.17
      2.320.1213-03-2021 00:000.21
      2.20.1220-03-2021 00:000.26
      2.380.1427-03-2021 00:000.24
      2.40.1503-04-2021 00:000.27