Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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.

 

 

Himanshu_13_0-1627378611598.png

Himanshu_13_1-1627378647958.png

 

Regards,

Himanshu

 

1 ACCEPTED SOLUTION

@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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

4 REPLIES 4
BA_Pete
Super User
Super User

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

 



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




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?

 

@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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Anonymous
Not applicable

haha yes 55 cents doesnt matter on a forecasted revenue of $199m but still wanted to show it on the details page as business does reconsillation when they export and they match the DP values as well. Rest, i'll create a seperate measure and i think that will work.

 

Thanks for the support !!!

 

Regards,

Himanshu

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.