Dual axis with scaled values

[Anonymous]

Hi all,

I am trying to visualize two values on the same chart. The problem is that the axis has only one value. On tableau you can have two axis at the same time with different scales so they are easily comparable. In this case I want to plot the value and the number of transactions to be able to compare them. Is there a way to have different axis scales for ach of the measures? In the screenshot because the axis only has one measure the number of deals is too low compared to the value.

I come from tableau and it is very easy there, but I can't figure it out on Business BI.

Thanks!

[Anonymous]

Hi,

You can have Line and stacked column chart for this.

Here I am showing Total sales on the bars and total orders on the Line chart.

Thanks.

[Anonymous]

Thank you. Yes, I was trying to use this type of chart, but it does not show me they way I would like. That is exactly they way that is shown on your example.

See the screenshot below:

[mussaenda · Accepted solution]

Put the value on line values not in column values

[Anonymous]

OMG, how could I not see! Thanks!

[Anonymous]

Glad you were able to solve it.
Thanks.