Forum Discussion

Leah-H's avatar
Leah-H
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Adjust numeric formats for aggregates inside tooltip

I've been looking around to see if this question has already been answered but I'm not finding it if it is. I'm trying to set the nunber of decimal places for aggregated columns in the tooltip. The c...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Leah-H,

     

    Based on my test, without the option to use the Format option under Model tab, I was also not able to affect Power BI's internal calculation which shows up in the tooltip by using ROUND or TRUNC in this scenario.

     

    In addition, as the idea for supporting DAX measures against Tabular models is alread started, I think the Format option under Model tab will also be available against Tabular models when that idea is complete.:smileyhappy:

     

    Regards

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

Phil_SeamarkYes but above the Toolip Measure you'll still see that Number!

 

Math

29.21599999999998

29.2

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Oh yeah, I see what you mean now.  I reckon Sean is on the money with the TRUNC function.  Works for me! :)

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Phil I hope TRUNC works - however I would've thought ROUND would also work :smileyhappy:

     

    Let's see...

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      I tried it here and worked for me.  

      • Leah-H's avatar
        Leah-H
        Icon for Advocate I rankAdvocate I
        9 years ago

        Thanks for the suggestions! It's true that I need the variable to be numeric since I'll be doing calculations on it, and then the issue here is cropping up due to the automatic display of the summarized numeric value in the tooltip. Using TRUNC is a good suggestion, but it does not seem to solve the issue for me. Is there a setting you're able to switch that might explain why it's working on your end and not mine? 

         

        As of now ROUND and TRUNC are both exhibiting the same behavior for me. And I'd prefer to use ROUND over TRUNC since that would give me more accurate averages when summarized. 

         

        (I recreated and saved the workbook this time, hence the different average score)