Combo Custom Combination Chart - Same functionality as in Excel

[XiaoHongJiang]

Is the functionality "Combo custom combination graph" available in PowerBI? this functionality is available in excel. 

For instance:

I have the data with Target/Qty/Qty12M, and Ratio%.

I need to make a combo chart with:

1. X Axis - Month

2. Y Axis (Primary) - Qty with Bar /Target with line/Qty12M with line

3. Y Axis(Seconary) - Ratio% with line  

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Target	300	300	300	300	300	300	300	300	300	300	300	300
Qty	213	432	432	324	23	467	674	223	443	111	32	321
Qty12M	213	322.5	359	350.25	284.8	315.1667	366.4286	348.5	359	334.2	306.7273	307.9167
Ratio%	71.0%	107.5%	119.7%	116.8%	94.9%	105.1%	122.1%	116.2%	119.7%	111.4%	102.2%	102.6%

 I need to make this combo custom combination chart in powerBI, same as in excel, please help.

[Anonymous]

HI @XiaoHongJiang,

I think 'line and stacked column chart' or 'line and clustered column chart' should suitable for your requirement.

Combo Chart in Power BI

BTW, these records not very suitable for visualization, I'd recommend you to use unpivot feature to transform records first.

Unpivot Data Using Excel Power Query

Regards,

Xiaoxin Sheng