filter a report according to the value of a parrameter

[amokrane]

Hello, is it possible to filter a report according to the value of a parameter.

let me explain:

I have a report that shows me the sales, turnover... from several agencies (6000), I would like each agency director to have access to just the appalling information about his agency, I thought I forced each user to enter the code of his agency when he wants to access the report and the report will automatically filter itself and display only the information that corresponds to that agency.

I don't know if it's possible to do this with Power BI or how to do it.

thank you.

[v-chuncz-msft · Accepted solution]

@amokrane 

You may take advantage of Row-level security with Power BI.