The report I use currently for S&OP uses a combination of a Bar, line, and area graph. In one chart I show the sales, columns, the demand each month, line, and inventory status, area chart. Is Power BI limited to a combination of two charts(i.e. line and bar) or has someone created a custom visual I am not aware of?
Thanks for the help,
Michael
Hi Michael,
I'm not aware of a custom visual like this so your options are to:
1. Use the column and line combo chart and switch the inventory status to either a column or line
2. Put it in another/separate chart. You could align it with the first chart to aid comparison.
3. Pin your chart from Excel to your Power BI dashboard. The limitation with the last option is you lose interactivity with the chart. In effect it's an image of the chart.
Mynda
