Forum Discussion

Namoh's avatar
Namoh
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Change multiple graphs into 1 graph with dropdown box(es)

Hi, I've searched the forum, but couldn't find a solution for my problem.   I've currently made 5 different graphs, which all look the same but all show a different measure.   These graphs take u...
Need Help
Show and Tell
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Namoh ,

     

    yes, that's possible.

    Check out the following video, here it's explained in detail:

     

    If you need any help, please let me know. If my answer helped you, I would be happy if you could give me a thumbs up.

     

    Best regards

    Denis

     

Namoh's avatar
Namoh
Icon for Post Partisan rankPost Partisan
5 years ago

I've got it working!!

BUT..............it's still not 100% what I'm looking for.

I now can click any of the 5 measures and the graph will change accordingly, perfect.

I've added a conditional formatting for the 1st measure and the graph shows perfectly green and red.

But when I change the measure to one of the other measures, the red and green are still according to the 1ste measure formatting. Can I set conditional formatting, in a way that it doesn't matter which measure I select the graph will show the same (below 0 red, above 0 green)?