cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Clustered Column in Percentage with line chart as secondary axis

Hello Community,

I have a quick question related with graphs that I have developed as pasted below:

However, I would like to show the clustered columns in % for each month (but when I am doing it, it splits total data as % split).

 

All I need is to display for each index/year-month on x-axis , the clustered columns between Late and On-Time in %, for instance I would like to see my clustered columns for 2019 November as 85% (On-Time): 15%(Late).

With excel you can simply obtain the desired result but it's difficul with Power BI. Appreciate help!

ChartChartVisual Build GridVisual Build Grid

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Clustered Column in Percentage with line chart as secondary axis

Hello,

 

As I understood, you want to see the ration between Late and On-Time columns in percents but only on labels, while columns still have to reflect absolute values. I found that it's possible to show labels in per cent of Grand Totals only but it looks like not your case.

I can recommend to ask in that thread also becuase they have more expretise regarding data modelling and visual that you use is core one.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors