Synced slicers when copying the report to another workspace

[Iryna_Khomenko]

So I need to adjust my sales report for several different audiences. For that I used "save copy" of the main report to a separate workspace and then adjusted each of them as needed.  

One of the requirements is to have several tabs of the report show current month and several - not, but only till the day when the month is officially opened. To save myself the energy for this ceremonial opening of the month, I created a date slicer, synced it with selected pages and adjusted it only once per month as opposed to changing filters on several pages. This I did in the main report. When I created a copy of this report to another workspace, the sync trick stopped working - I adjusted the synced slicer, but nothing happened. I deleted it and still - the data on all visuals remained "closed" as per this slicer when it existed. Any ideas are MUCH appreciated! 

[Iryna_Khomenko · Accepted solution]

@ibarrau , thank you so much for coming to resque that fast! You proposed solution is very good, the preselected slicer was all new to me - many thanks for that!

My case resolved easier than expected. Original idea was to create a slicer on a hidden tab and sync it with relevant tabs, but make it invisible there. But for whatever reason, that synced slicer when changed on the hidden tab where it was originally created - did not impact the other tabs. In the sync slicer pane, I made it visible for one of the relevant tabs (but decreased it to tiny size so it doesn't provoke the users) and when i change it on that other tab - the changes impact all other relevant tabs as planned. Still utterly confused about this - sync is sync, right? no matter which one of them you change - all should change. But not in this case. From original page - nope, from another - yes. 

[ibarrau]

Hi. There is no way of syncing slicers on different reports. When you "Save Copy" you are creating a new report. If you have multiple audiences that should see it's own rows. You can just use RLS for security on rows and Power Bi Apps to pick the reports each audience should see.

That should do the trick of audiences.

Regarding the selected thing you might want to take a look at Preselected Slicer custom visual. You can read about it here: https://github.com/PiConsulting/Pensadero/tree/master/Bi/Resoluciones/Preselected%20slicer

The custom visual: https://appsource.microsoft.com/en-us/product/power-bi-visuals/insiderscoop1611244107840.powerbi_cus...

I hope that helps,