Dual or multiple Y axis on power bi column and line chart

[Anonymous]

Hi All,

I'm having some trouble in creating a primary and secondary Y axis on a power bi chart with year as legend.

Let's say I have a monthly data of cost and sales for two years.

Year	Month	Cost	Sales
2018	Month 1	1000	5000
2019	Month 1	1100	5050
2018	Month 2	1050	4500
2019	Month 2	1200	5100

I want to create a time series chart as below, showing the actual values by month and legend coloured by the year. And I want say cost on the  primary Y axis and sales on the secondary Y axis.

This is a much simple chart to create in excel, but I'm having a hard time in finding a free power bi visual to create this. Any ideas or suggestions on this would really help!!

[ibarrau]

Hi, let's see. The combo charts work like this: The legend will only work for the bars. If you want to try something like that you have to create measures for each line. For example

• Axis: Month
• Legend: Year
• Value: Cost
• Line: two measures Sales2019 and Sales2020

That is how the chart works inside Power Bi. You can always try custom visuals like Amit suggests.

Hope that helps.

[amitchandak]

@Anonymous , In power bi legend, will work only for bar, not for the line.

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

Or create an idea:https://ideas.powerbi.com/ideas/