Forum Discussion
Post PartisanChange 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 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.
5 Replies
NamohHi, 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.
- 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
Most Valuable Professional
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