Forum Discussion

Arshadjehan's avatar
Arshadjehan
Helper I
6 years ago

Color saturation for Shape Map not working

 Hi,

I am trying to map actual budget expenditure through color saturation of Shape Map Visual.

When I use simple measure, it works fine, but as soon as I format the measure as Million, color saturation disappears.

Here is the formatted measure:

 

Actuals = format(SUM(Budget[Actual]),"#,##0,,")
 
Any Help?
Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Formatted number is like string/test. Please use unformatted number to color formatting.

    • Arshadjehan's avatar
      Arshadjehan
      Helper I
      6 years ago

      amitchandak 

      Thanks for the reply. But my requirement is displaying the figure in millions. I can achieve this in matrix but not intooltip of Shape map visual.

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    According to your description, it works well here.

    Here is my test table:

    I create two measures:

    Original Actuals = SUM('Table'[Actual expenditure])
    Actuals = VALUE(format(SUM('Table'[Actual expenditure]),"#,##0,,"))

    And they show as follows:

     

     

    For your problem, i think it is related to your data, such as "13300000","13400000","13500000". 

    And they all show as "13" after changing its format to million.

    So the color in Shape map display the same instead of gradation.

     

    Best Regards,

    Giotto Zhi