How to relate sync slicers and Visual level

[rimgri]

 Hey champions,

I need to tackle the issue when selecting different bookmarks and moving through the pages there will be the same granularity in the visual.

There are two options for granularity:

Overall (Team is not selected)- shows Teams granularity

Selected one of the Team -  shows visuals in Name granularity

This is solved with bookmarks, but as I mentioned, it works whwn we are navigating in the same page, but the problem comes when you start moving from page to page (Team filter is sync between pages).

If I select one of the team and go to another page the data is filtered by filter, but visuals remains in that granularity that was seleted the last one in that page. And if it was selected in global I get Team level in the visual

But it should look like this (Name level), because Team is filtered:

I wan't to achieve that if filter is selected (HASONEVALUE) than show visuals in Name granularity if not - Teams.

There is a file for those who what to play around:

https://drive.google.com/file/d/1eH_8CZwLVR_-d9UGcvKUrbru2FDnfaKa/view?usp=sharing

Thanks in advance!

[rimgri]

@Anonymous  you are a genius!

[Anonymous · Accepted solution]

Hi @rimgri ,

Try the latest field parameter feature.

Start preview here.

Attached PBIX file for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[lbendlin]

That's not something you can do. Consider report level filters instead.