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
Naveen29
Helper II
Helper II

UI Help

In the line chart the data labels are showing as Millions ( I have changed Display units as millions under data label) ,but when I hover the mouse on the data labels , the values showing in the orginal format. Ex: 210000 insteaf of 0.02 M. How to fix it?

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Naveen29 , I doubt the tooltip takes the label format. Please try to change the default format using measure/column tool and try

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

v-rzhou-msft
Community Support
Community Support

Hi @Naveen29 ,

 

For the default tooltip feature, you can't do custom on it. I'd like to suggest you write a measure formula to format values to add 'unit'. Then you can create a report tooltip page with that formula and binding it to your visual. 

For reference:

Create tooltips based on report pages in Power BI Desktop 

DAX Text - FORMAT function 

Here I create a card visual in my report tooltip page and use million unit.

1.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-rzhou-msft
Community Support
Community Support

Hi @Naveen29 ,

 

For the default tooltip feature, you can't do custom on it. I'd like to suggest you write a measure formula to format values to add 'unit'. Then you can create a report tooltip page with that formula and binding it to your visual. 

For reference:

Create tooltips based on report pages in Power BI Desktop 

DAX Text - FORMAT function 

Here I create a card visual in my report tooltip page and use million unit.

1.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-rzhou-msft  - I have tried this and it is working fine. But , one challenge over here is the color series is missing for line chart.

 

Hi @Naveen29 ,

 

If you want to show lines in different colors, I suggest you to try legend function in line chart. If this reply still couldn't help you solve your problem, please share a sample with us and show us a screenshot with the result you want.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Naveen29 , I doubt the tooltip takes the label format. Please try to change the default format using measure/column tool and try

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.