Forum Discussion
Combo Custom Combination Chart - Same functionality as in Excel
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.
1 Reply
HI XiaoHongJiang,
I think 'line and stacked column chart' or 'line and clustered column chart' should suitable for your requirement.
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
