Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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
Formatted number is like string/test. Please use unformatted number to color formatting.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |