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

[Namoh]

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 up a lot of space (have similar visualisations with the same setup multiplied by 5) and I would like to reduce them to 1 graph with a dropdown box where I can select 1 of the 5 measures.

See below 3 of the graphs I've made, type of graph is each time the same, Y-as is the same, only thing that (can) differs is the month shown and the type of loss.

I would like to have 1 graph with 2 dropdown boxes / filters, 1 filter for the months, and 1 for the type of losses.

It's probably something easy, but I can't find out how to do this.

Any help would be much appreciated. 

[Namoh]

@selimovd , thanks for your help. Do you know how I can make a conditional formatting for the different measures?

[selimovd]

As far as I know not at the moment. You can do a conditional formatting for the measure, but the values change depending on the slicer.

An alternative would be to place a few visuals on top of each other and show or hide them with the selection pane and bookmarks.

Check the following article for more information:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks

Best regards

Denis

[Namoh]

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)?

[selimovd · Accepted solution]

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]

Hi, thanks for the reply.

I've tried to follow the video, but at a certain point, I get an error. 
It's around 3:34 in the video where I get stuck, see below screenshots.