Custom data labels

[Anonymous]

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.

Thank you

Poojitha

[Anonymous]

@Anonymous - 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! 

Regards,

Sumanth

[Anonymous]

@Anonymous 

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

[Anonymous · Accepted solution]

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

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

[Greg_Deckler]

@Anonymous 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