Secondary axis on a filter

[marinejlsz]

Hello, can anyone help?

I am trying to show the values of the online sales on secondary axis, as the numbers are much smaller than the "vendite negozio".

But unfortunately because it is a filter, I would need to filter first by Vendite negozio and then by vendite online. And it doesn't let me.

Any thoughts? If the purple line was on the secondary axis i could see if the seasonality of sales "vendite negozio" and "vendite online" matches.

Thanks for your help,

Marine

[marinejlsz]

Thank you!!

[ibarrau · Accepted solution]

Hi, when you are using legends, then you can't make two axis. The secondary axis is only available when you have one measure for value and no legend. Then you can create a secondary one with different color.

In order to fix this you can create two DAX measures. One filtering "vendite negozio" and another filtering "vendite online". Then add one as value and the otherone as secundary value. Don't forget to remove the legend first.

This is an example of the simple measure you can create

CALCULATE (
    SUM(Table[Importo Venduto]) , Table[Business Unit] = "vendite negozio"
)

I hope that helps,