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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors