Line and Stacked Column Chart - Multiple lines split by years

[Anonymous]

Hi,

I would like to have a line and stacked column chart that has columns for a specific year (e.g. 2020) and split by a certain column series, while lines that are split by a range of years (e.g. 2013 - 2020).

Below is an example:

I have attempted to replicate this on PowerBI, however, I do not seem to be able to split the lines by years. The best I can get is this:

Would like to know if its possible to achieve the 1st picture, thank you!

[amitchandak · Accepted solution]

@Anonymous , In power Bi You can not split Secondary -y-axis or the secondary measure (Line in case bar and stacked) On legend.

You can check for some custom visual: https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

Or log or vote for an Idea at https://ideas.powerbi.com/ideas/