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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Aakex
New Member

Format two different data labels in column chart

Dear all,

I am working to make my chart like this. The one column shows the total number and the another shows the Percentage. One column is related to another. For eg. In first column there is the total number and in another column you can see the 92% which is related to first column. How can I make this in Powr BI?Capture.PNGThanks in Advance.

Sincerely,
Aakesh.

 

3 REPLIES 3
Anonymous
Not applicable

Hi @Aakex,

 

I'll suggest you use a "line and stacked / clustered column chart" instead. I've been where you are before and adding the same value to both column and line (displaying one of them as "Percent of grand total" or creating a measure) worked for me. You'll need to play a bit with the data labels to don't get it messy.

line_column_chart.png

 

 

I hope it helps.

Thank You! 🙂

Anonymous
Not applicable

Hi Aakesh,

 

If my answer was satisfactory, could you mark it as it? Thank you!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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