Line and Clustered column chart - works in Excel, not in PowerBI
currently converting our Excel-reports to PowerBI-reports. Now I know not everything can be translated one-on-one, but I currently have this chart in Excel which I would really like to translate as good as possible:
I've managed to recreate the bar-part of this chart quite easily using a 'Clustered column chart' (different figures due to outdated data inside PBI at the moment) - I've added the settings I've used in the 'Visualizations'-part of the chart as well.
I've managed to create the % as well (three seperate measures), so like this:
However: how can I combine these in one chart (or two charts with one behind the other)? I've tried turning the chart into a 'Line and clustered column chart', but somehow it ignores the 'Sales Category' for the markers and groups them together:
My second idea was to put the %-chart 'behind' the value-chart and make the columns completely transparent. I can't seem to make the columns transparent though, only a 'full' color, so this didn't work either.
Does anybody have an idea on how to achieve somethings like the image from Excel in PowerBI?