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.
@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! 🤠
