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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors