cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Naveen29
Helper I
Helper I

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

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors