cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marinejlsz
New Member

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

 

marinejlsz_3-1642408862722.png

 

 

 

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

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,


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

Happy to help!

LaDataWeb Blog

View solution in original post

2 REPLIES 2
marinejlsz
New Member

Thank you!!

ibarrau
Super User
Super User

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,


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors