How to combine 2 chart into 1 ?

[admin11]

Hi All

I have create 2 chart , only sales by year Bar chart and another one count by invoice by year. I like to combine these 2 chart into 1 , can some one advise me.

https://www.dropbox.com/s/akm5fwbayzz90ns/PBT_V2021_333%20Combine%202%20chart%20into%201.pbix?dl=0

My PBI file 

Paul

[AlexisOlson]

Have you tried the combo chart?

Convert your column chart into a combo chart and put SALES_ in the Line values field.

[admin11]

@AlexisOlson 

Thank you for sharing the link very useful.

I stuck at how to show 2nd axis. 

https://www.dropbox.com/s/vzc6z9xx4xbzb4y/PBT_V2021_333%20Combine%202%20chart%20into%201_v001.pbix?d...

Paul Yeo

[AlexisOlson · Accepted solution]

I don't know how to make it any simpler. Maybe a screenshot will help.

[admin11]

@AlexisOlson 

Dont forget to share the PBI file, So that i can figure out how you do it.

Paul

[AlexisOlson]

It's the same file with like two extra clicks (which I've explained). I don't think it makes sense to upload another copy.

[admin11]

@AlexisOlson 

Thank you so much , it is very simple.

Paul

[admin11]

@AlexisOlson 

Thank you very much , can you pls share the PBi file ?

Paul