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

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

You can create a new measure just for the Tooltip that uses the FORMAT function.  You'll see here I've set the decimal places to 2 places.

 

Try this

 

My Tool Tip = FORMAT(
					CALCULATE(
						AVERAGE('PERSIST WeatherReading'[baro])
						)
				,"#,000.00")
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.