cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Custom data labels

Hi all,

I am using Line and Clustered Column chart in my report. I have turned on the data labels with "display units" as "Thousands".

I would like to show actuals values for the red line and for the green and blue bar, need to show in thousands.

Showing red line as thousands is always shown as 0K as they are percentage value and will always be less than 1000 which results in 0K.

Is there a way I can show actual values for the red line. Please sugegst.

 

Capture.JPG

 

Thank you

Poojitha

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Memorable Member
Memorable Member

Re: Custom data labels

hi @POS3002 - I have used "Line and clustered column chart" from the marketplace. 

 

Sumanth_23_0-1600184922289.png

 

Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Custom data labels

@POS3002 Might be able to override using the technique listed in Chelsie Eiden's Duration. https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

 

Custom format strings:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Memorable Member
Memorable Member

Re: Custom data labels

@POS3002 - You can also consider using a Dual axis visual so you can display units on different charts - as seen in the below screen grab 

 

Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

 

Dual Axis.jpg

 

Regards,

Sumanth

Highlighted
Helper IV
Helper IV

Re: Custom data labels

@Sumanth_23 

Could you please suggest the visual name you have used from the marketplace.

Highlighted
Memorable Member
Memorable Member

Re: Custom data labels

hi @POS3002 - I have used "Line and clustered column chart" from the marketplace. 

 

Sumanth_23_0-1600184922289.png

 

Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Users online (848)