Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Need Help with Visualizing Field Parameters and Editing Secondary Axis!

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 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • gadielsolis's avatar
    gadielsolis
    Resolver III
    2 years ago

    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.

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

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