Combo Chart with multiple Lines and one Column instead of multiple clustered Columns and one Line

[LFDM]

Hy, I am new to Power Bi and having some trouble in creating a benchmarking Dashboard.

I would love to have a combo chart identical to the standard (line and clustered column chart) one. Just with multiple line values and one bar value, instead of multiple bar values and one line value.

Here you see the regular result: The line represents the "benchmarked company". The bars represent the "peers". While this is the only graph that allows me to select bechmarked company and peers in two seperate slicers and actually display it, I would need it the other way around, to make sense for the reader.

So we would have the benchmarked company single value as a bar/coumn and then (in this case two) lines with the peer values.

 

[Eric_Zhang · Accepted solution]

@LFDM

The legend would only affect the columns in a combo chart, so by default, there're two columns and one line. As a workaround, you can leave the legeng field blank and create individual measures and put those measures to line values  if you'd like the epxected output.

[LFDM]

@Eric_Zhang

Thank you! So at least I know, that this approach does not rally work.