Default selection in page navigation slicer

[Anonymous]

I have 5 pages in my report and I use a slicer in each page having the page names as dropdown option. Page navigation is working fine. The problem is with the slicer selection.

Example: If select "Disposals" from the slicer and hit on generate button, I'm able to navigate to Disposal page but the slicer value shows "New Asset Setup". 

I'm using below formula on button action where pagename is the table I manually created with the name of pages in the report

 Any help would be appreciable!

[Alex87 · Accepted solution]

Hello,

If I understood correctly, you can navigate to the corresponding page but the slicer does not have the right value. I would say that the slicer is not synced across the pages (view/sync slicers). Sync the slicer between the pages and normally it should fix the problem. If it does, please mark my post as the solution.

Best regards,

Alex

[samratpbi · Accepted solution]

Hi,

I have created a table as you have mentioned and created a button for Generate Report. 

Then simply copy paste this into all your pages and make the slicer as Sync slicer. Now For Generate Button Page navigation, use conditional page navigation and create a measure like below:

Page Selected = SELECTEDVALUE('Pages'[Pages])

and use this measure in your conditional page navigation. 

Hope this resolves your problem.

If this helps to resolve your problem, then please mark it as solution, Thanks!

[Alex87 · Accepted solution]

Hello,

If I understood correctly, you can navigate to the corresponding page but the slicer does not have the right value. I would say that the slicer is not synced across the pages (view/sync slicers). Sync the slicer between the pages and normally it should fix the problem. If it does, please mark my post as the solution.

Best regards,

Alex