Buttons, bookmarks and page filters question

[Anonymous]

I have buttons on the first tab. I have a table visual on the second tab. 

On the tab with buttons, I want clicking on each button to take me to the second tab with a specific filter on the page. Lets say I have 3 distinct buttons on the first tab. Clicking the first button should take me to the second tab where the Filter on the Page is a certain condition. Clicking on the second button should take me to that same second tab where the Filter on the Page is another distinct condition. Clicking on the third button should take me to that same second tab where the Filter on the Page is yet another distinct condition. 

My first thought was to create 3 separate tabs with the table visual and use the option "page navigation" for each of those buttons. But that would be creating the same 20 columns in the table visual 3 times and I want to avoid that. My second thought was to use only that second tab with the table visual and create 3 Bookmarks for each of the 3 distinct Filter on the Page conditions. However, that isn't working. I have tried unchecking Data, etc and tried to follow instructions on already existing forum threads. Can someone please let me know step by step procedure to do this even if it's not Bookmark method and something else? I want to avoid creating multiple tabs. 

Thank you! 

[jdbuchanan71]

Sorry, I don't see an attached file. 

[jdbuchanan71]

You would have to add Col_1 and Col_2 as page level filters and set those along with setting the field parameter selection.  So I added Continent as a page level filter and 2 bookmarks for Asia and NA.

I set the parameter filter to continent and the continent to Asia and make the Asia bookmark

I set the parameter filter to continent and the continent to North America and make the NA bookmark.

When I click on the NA button on page 1, it goes to page 2 and sets both selections

Paramater = Continent

Continent = North America

Updated file attached.

[Anonymous]

Thank you so much @jdbuchanan71 ! Do you mind taking a look at the attached file? I am still kind of stuck. On my Page 1, I have the buttons clicking on which should show the results in Page 2. Clicking on Red button should show all the Count_Red=1 on Page 2. But I also have filters on Page 1 and I am sorry I didn't mention that fact before. So in this case, if company A is selected and the Red button clicked, it should take me to Page 2 and show all the Count_Red=1 for company A. I have synced the slicers between Page 1 and Page 2 but this doesn't seem to work. When I click on Yellow button, it takes me to Page 2 but shows everything and the Filters on this Page shows Count_Green as the parameter although I had bookmarked it for Yellow. Why would the bookmarks be getting reset? Thank you! 

--Editing -- I could not attached my pbix file. There is no option here. 😞

[jdbuchanan71]

Yes, what you are looking for is doable with a Field Parameter.

Go to Modeling > New parameter > Fields

Here you select the three fileds you want to switch between in your visual so for mine I selected State, Country, Continent.  Uncheck "Add slicer to page" in the bottom left:

This will create a new table in your model with the fields you selected.  You add that to your table on page 2 and also to the page filters.

What a field parameter does is changes the columns that are displayed in a visual based on the select so if I select continent it will show that column, if I select state it will show state.  

Then you set the filter in the page filters to pick the column you want to show and update your bookmark.  Now, when a user clicks on the State bookmark, it will jump to page 2 with State selected and that column will show in my visual.

Updated .pbix attached.

[Anonymous]

@jdbuchanan71 This is getting close to what I need for sure.. so thank you! However, I am looking for a condition within the column. In your example, how do I set the page filter to say Continent = Asia? 

In my case, I have buttons on page 1 which should take me to page 2 and show col_1 = 1. The values in my col_1 are 1, 0 and blanks and I want to see only col_1=1. Similarly, clicking on the other button should show me col_2=1 from the same table visual on page 2. Would that be doable with this? The Basic Filtering on Page Filters isn't giving me an option to select only 1 out of 1, 0 and blanks. 

[Anonymous]

Thank you for this pbix attachment!!! It still isn't working for me. Would that be because your bookmarks are selecting 3 different options from the same column whereas my use case is for selecting values from 3 different columns? In my case if I have button 1, button 2 and button 3, I want button 1 to use bookmark 1 which is col_1 = 1. Button 2 should use bookmark 2 which is col_2=1. Similarly, button 3 should use bookmark 3 which is col_3 = 1. The table visual on my page 2 should be just one display but it should dynamically change based on what columns and conditions we choose. Is that doable? Thank you! 

[jdbuchanan71]

I created 3 bookmarks on Page 2, one for each continent, this is how each one is configured.

By creating the bookmarks on page 2 with "Current Page" selected, I can put the bookmarks on page 1 in a bookmark navigator and, when someone clicks one, it will jump to page 2.

I have a added Continent as a page filter on page 2, set the continent to Asia and update the Asia bookmark.

Do this for each bookmark you have to set it in the correct configuration.

Group the three bookmarks by ctrl + clicking them in the list, right clicking and selecting group.

Go to page 1 and insert a button > navigator > bookmark navigator.

In the Bookmarks well, select group 1 to add just those bookmarks to this navigator.

Now, when you click on a bookmark on page 1, it will jump to page 2 with the continent filtered.

I have attached my sample .pbix for you to look at.