Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
KarenL7
Advocate III
Advocate III

Power BI Graphs - Data Labels

Hi

 

I have just upgraded to Power BI April 2022 - and I have just created a clustered bar chart and after a little while finding my way around the new formatting features - I have now have a question about the data labels that are in the chart - they same to have changed between versions?  i have 2 screenshots if that helps - can anyone help as to why - 

 

September 2021 (we had not upgraded for sometime)

 

KarenL7_0-1650962068679.png

 

April 2022 - Outside End is missing

 

KarenL7_1-1650962155382.png

 

 

Also does anyone know if you can get totals to show as a data label on a clustered bar chart?  

 

Thanks

 

Karen

4 REPLIES 4
Mayank_Yavda
Resolver II
Resolver II

Hi @KarenL7,

 

Here is Line and clustered column chart With Custom Tooltip which will help you to get custom label placement outside the columns and also you can put total value as label you just need to create a dax measure to sum all the values(that you want the total of) and put it in label field.

 

Line and clustered Column Chart with custom tooltip PBIVizEdit.comLine and clustered Column Chart with custom tooltip PBIVizEdit.comLine and clustered Column Chart with custom tooltip PBIVizEdit.comLine and clustered Column Chart with custom tooltip PBIVizEdit.com

 

 

Download link for the custom visual file in this page

https://pbivizedit.com/gallery/line-and-clustered-column-with-custom-tooltip 

 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

  • anyone, irrespective of technical skills, can create their own visuals
  • 15 minutes to create a visual from scratch
  • opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problem/errors.
You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

Thanks,
Team PBIVizEdit

KarenL7
Advocate III
Advocate III

Okay

 

I have found the answer to this - This does appear when I remove the legend - so it is nothing to do with the upgrade - my fault for getting frustrated with the new format so apologies for anyone who my read my question!

 

However I am curious to find out if anyone will know if the totals will appear on a stacked column chart when using a legend if anyone reads this post. 

 

Thanks!

Karen

Hi @KarenL7 

Thanks for reaching out to us.

What does the total look like on the stack column chart? Not sure which one you're referring to, is there any screenshots?

 

Best Regards,

Community Support Team _Tang

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

Hi

 

Just to confirm that the totals on the chart this is the stacked bar chart without the legend and has the totals on the outside end -  Please see an example below

 

KarenL7_3-1651228256208.png

when I add in a legend the overall totals are removed and the data labels show for each individual - which is fine however -

KarenL7_2-1651228147690.png

 

 

I was just wondering how to show how to include the overall totals as well in the chart - but cant see an option anywhere as I would like to include them on some of my charts.

 

Thanks

 

karen

 

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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