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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
KarenL7
Advocate II
Advocate II

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 II
Advocate II

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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