Forum Discussion

osinquinvdm's avatar
osinquinvdm
Advocate II
9 years ago
Solved

Using % in Color Saturation of Shape Maps

I want to use color saturation on a shape map to highlight areas where a ratio is the highest.

It works fine if I use and unformatted measure ratio=subset/total.

But this looks ugly in the toolip.

So I want to format the ratio as a percentage, using Format(ratio;”0.0%”) but then powerBI will not let me use that measure in the color saturation field

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    osinquinvdm

     

    When using Format() function, the result will become text type so that the visual can not recognize it as numerice value for color saturation. Please format it under Modeling tab.

     

     

    Regards,

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    osinquinvdm

     

    When using Format() function, the result will become text type so that the visual can not recognize it as numerice value for color saturation. Please format it under Modeling tab.

     

     

    Regards,