Color saturation for Shape Map not working

[Arshadjehan]

 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?

[v-gizhi-msft]

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 

[amitchandak]

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

[Arshadjehan]

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