Need Help with Visualizing Field Parameters and Editing Secondary Axis!

[Anonymous]

Hello, I need help with visualizing field parameters and editing the secondary line axis. I'm feeling very desperate as I've been stuck for a week.

The main issue I'm facing is that I can't find a way to link different secundary line charts to their respective columns, as they remain static and don't respond to the parameters. Additionally, if possible, I would like to change the color based on the parameters. but I cannot find a way.

Main graph

Ideal interactions

Color pannel

Can someone assist me? Is there any DAX formula I can use? Do I need to hide something in a specific way?

Thank you very much!

P.S.: I'm attaching the file below.

file 

[Daniel29195]

@Anonymous 

im not sure if this is what you want 

check below 

if you select on  total sales , it shows blue 

if you select on total units , it shows red 

steps: 

modify your field parameter as below ; 

step 2 :  create color measure

step3 : apply function to columns color

this should work .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution !✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[gadielsolis]

Hello,

It would be great if you could provide a sample in PBI (not specifically the real data). If so I'd be more than happy to help you.