Forum Discussion

alsolok's avatar
alsolok
Helper 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

help me please

 

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.

5 Replies

  • Pragati11's avatar
    Pragati11
    Super 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.

     

  • alsolok's avatar
    alsolok
    Helper II
    4 years ago

    Thanks,

     

    But the visual Table heatmap does not work. I use Table heatmap

    • Pragati11's avatar
      Pragati11
      Super User
      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.
      • alsolok's avatar
        alsolok
        Helper II
        4 years ago

        yes, I use heatmap table personnalized.

        Thanks 

  • v-easonf-msft's avatar
    v-easonf-msft
    Community 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