Forum Discussion

ZholboldyA's avatar
ZholboldyA
Regular Visitor
3 years ago
Solved

Filter

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?

Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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

4 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Super User
    3 years ago

    ZholboldyA 

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

    • Mahesh0016's avatar
      Mahesh0016
      Super User
      3 years ago

      ZholboldyA 

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

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    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