Forum Discussion

marinejlsz's avatar
marinejlsz
New Member
4 years ago
Solved

Secondary axis on a filter

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

 

 

 

 

Need Help
  • ibarrau's avatar
    ibarrau
    4 years ago

    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,

2 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    4 years ago

    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,