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.
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
4 years ago

Hi alsolok ,

 

In your table visual --> under formatting options --> Field Formatting

Choose your measure name in the drop-down (in my case it is Total Price)

Then set value decimal places --> 0

This will remove decimal places to the value you are displaying on the table visual as a heatmap.