Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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!
Proud to be a Super User!
@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
Proud to be a Super User!
Could you please suggest the visual name you have used from the marketplace.
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!
Proud to be a Super User!
@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