Different visualizations / chart types on a single axis

Situation:

You have two measures on a single axis but for readability purpose you want to display one as a column, the other as a line. How to do that?

Solution:

You can assign different property values to an individual measure. These property values will override values from higher level (chart-wide). To do that select the measure and modify it, go to Advanced properties tab and press Add:

• Contributor: SeriesProperty
• Property name: type
• Use expression: "column"

This will make one of the measures display as column instead of a line on a line chart. You can pass also other values like enable data labels only for that measure. To do that instead of property name: type specify property name: dataLabels.enabled and Use expression: true