Triple Combination Chart
I need to create a triple combination chart consisting of clustered and stacked columns, with line charts on top of it. See the picture below for reference. Does anyone know of a custome visual that can accomplish this? Alternatively, is there a way to incorporate R into a visual to accomplish this? I need one clustered column with two stacks and one cluster with 1 stack. I have two lines I need charted as well. It would look like the drawing below:
Change chart type of series in combination charts
In Excel, you can change the chart type of each series on a chart. In Power BI it would be handy to allow users to be able to switch the chart type within combination charts for different series. Such as if the main set of series will be lines but there's also a column chart you want to overlay. The current combination charts allow you to slice measures on the column component but not the line component. Even if you could allow the user to switch the chart type of the main and secondary, this would widen the types of combination charts that users could build and reduce the need to rename fields manually in combination charts.
