Filter

[ZholboldyA]

I set up a report so viewers can create a report, Is it possible to make a built-in filter on all pages or in one page so that it automatically appears when creating a report?

[v-yueyunzh-msft · Accepted solution]

Hi , @ZholboldyA 

According to your description, you make a report and you want to make the other people show different data when they create a report based on your dataset. Right?

If this , you can create RLS in your dataset.Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.

For more information, you can refer to:
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[ZholboldyA]

when the viewer creates a report, this filter is not saved

[Mahesh0016]

@ZholboldyA 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Mahesh0016]

@ZholboldyA 

>>Select Slicer >> go to view tab >> click sync Slicer >> Right side Sync slicr add and sync with all pages .