Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Tooltip Formatting

Hi All,

 

I have set the decimal places to zero for my dashboards but the toottip seems to show the decimal places. How can the tooltip be formatted? I cant see any option to format the values in toot tip.

 

 

 

Regards,

Himanshu

 

  • BA_Pete's avatar
    BA_Pete
    5 years ago

    Anonymous ,

     

    Either override the measure DP at visual-level on your details tab page (if you don't need the tooltip to show the higher DP), or create a new measure "myMeasureZeroDP" which is just '= [myMeasure]' but can be set to zero DP for pages that need it, and the original measure with 2 DP can be used on pages that need it.

    Another option would be to create your own Tooltips, then you can display them however you want.

    https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

     

    For what it's worth, I can't imagine anybody needs to see 55 cents on the end of a $199m value.

     

    Pete

4 Replies

  • Hi Anonymous ,

     

    Set the decimal places at measure-level rather than visual-level.

    Select your measure from the fields list, then on the Measure Tools tab at the top of the Desktop window you can change your DP to whatver you want. This should then force through to tooltips.

     

    Pete

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      But I dont want to format the measure as I have used decimal places in my details tab page ( tabular report), so i want to have 0 decimal places only in the dashboards and tool tip. is this possible?

       

      • BA_Pete's avatar
        BA_Pete
        Super User

        Anonymous ,

         

        Either override the measure DP at visual-level on your details tab page (if you don't need the tooltip to show the higher DP), or create a new measure "myMeasureZeroDP" which is just '= [myMeasure]' but can be set to zero DP for pages that need it, and the original measure with 2 DP can be used on pages that need it.

        Another option would be to create your own Tooltips, then you can display them however you want.

        https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

         

        For what it's worth, I can't imagine anybody needs to see 55 cents on the end of a $199m value.

         

        Pete