Forum Discussion

alsolok's avatar
alsolok
Icon for Helper II rankHelper II
4 years ago
Solved

table heatmap format decimal

Hello,   I am making a visual table heatmap whose format of my measure (indicator) is in integer, the problem that I have the restitution gives me decimal values which I cannot format in integer h...
Need Help
Show and Tell
Tips and Tricks
  • Pragati11's avatar
    Pragati11
    4 years ago

    Hi alsolok ,

    Are you saying you are using a custom visual Table Heatmap?

    In that case you can't do that. Custom visuals have their own challenges and limitations.

    I would suggest 2 things here:

    1. either you don't show Data Labels on your custom visual due to it's limitations
    2. go with creating conditional formatting on a table visual in Power BI to show a heatmap kind of view and then display data labels.
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi,  alsolok 

If you mean you want your measure to return decimals instead of integers, you can try using the "FORMAT " function to format your data results first.

New measure=FORMAT([Old nesaure],"Fixed")

Best Regards,
Community Support Team _ Eason