Forum Discussion

Leah-H's avatar
Leah-H
Advocate 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

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

I tried it here and worked for me.  

Leah-H's avatar
Leah-H
Advocate 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
    Microsoft 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...