Line and Column visualization

[sacheu]

In my report, I have 

1 line chart with multiple lines series 

1 column chart with 1 series

They have a common x axis date. I want to overlay the line chart with the column chart to show relationship between these 2 sets of data.

The problem is in the Line and stacked column chart or Line and clustered column chart, I can only have 1 line and multiple columns. And my data is opposite. I have 1 column and multiple lines.

Is there a visual which allows me to have 1 column and multiple lines?

[v-lionel-msft · Accepted solution]

Hi @sacheu ,

You need to represent the value of each line with a measure and add them to the visual.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Not aware of one - but there's always Charticulator...