Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
menphis21
Helper IV
Helper IV

Selecting a field parameter depending on another field parameter

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 1Graoh 1Graph 2Graph 2

1 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

View solution in original post

4 REPLIES 4
tony41235346
Regular Visitor

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.

NikhilChenna
Continued Contributor
Continued Contributor

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!

 

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.

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors