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 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)

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Unfortunately this is something that is unbereable with models that have thousands of measures.

        I think Power BI team should work on a way to allow custom formatting also on tooltips, the same way they are possible in measures etc...