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")
  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    So maybe try this...

     

    My Tool Tip = FORMAT(
		CALCULATE(
			< your calc here > 
			)
		,"#,000.0")

     

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

      I would have thought text for your Tool Tip would be fine

  • 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...