Selecting a field parameter depending on another field parameter

[menphis21]

Hello

I have a graph where the X Axis is the Service Line and the column legend is the Industries.

and i have another page where i do the same analysis but with Industries on the x-Axis and the column legend as Service Line (Cf screenshots)

i want to merge these 2 slides in one slide by adding a button.

I created a field parameter based on these 2 fields , Service Line and Industries , to let the user choosing by a button what analysis he want.

But depending to his selection, i need to create a new field parameter that change depending on the selection of the 1st parameter and choose the inverse...

How can i do it ?

Thank you

Graoh 1Graph 2

[tony41235346]

Hi @menphis21, the simplist solution is to creat an one-to-one relationship between the two field parameters with the field order as a key, then include a slicer for the main field parameter only.

[Marii39]

I just had the exact same problem and your solution worked perfectly!!!! 
You saved me. Thank youuuu

[NikhilChenna]

Hi @menphis21 ,

Instead of creating the visual on 2 different pages you can make use of bookmarks and hide the visual based on the selection of a button.

1. Create a 2 button one with name as Service Line and another as Industries.

2. Add the second visual on to the first page itself.

3. Go to the view table and click on bookmarks tab and selection pane tab.

4. Create bookmarks for sevice by hiding the industries button and industries visual and do vice versa for another bookmark.

5. assign the bookmarks to the button.

6. This will help you resolve your issue.

Go through this links  it will be easy to understand and follow the steps,

https://www.youtube.com/watch?v=QUcW8gudhLw

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[menphis21]

Thank you @NikhilChenna ,

There is no another way to do it ? 

I dont have only 1 graph, its one page with 5 graphs base on this configuration.

[NikhilChenna · Accepted solution]

Hi @menphis21 , Orelse you can do one thing make use of page navigation button, keep your graphs as there are and use button and assign page navigation.

https://learn.microsoft.com/en-us/power-bi/create-reports/button-navigators#:~:text=Navigator%20%3E%....

Check out this link.

Regards,

Nikhil Chenna