Skip to main content
Microsoft Idea

Power BI

Under Review

Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

Vote (51) Share
Wouter's profile image

Wouter on 20 Dec 2014 05:03:19

Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

While user A opens a report the filter is set to his/her name (or his/Hers departement he/she is connecten to) while user B opens the report the filter is set to User B. Users not should not be able change that filter.

That would be great

Administrator on 20 Dec 2014 07:35:44

Do you mean at the dashboard? Adding filters in general is something we'd like to add, and these 'standard' filters could be options as well. Thanks for suggesting! If others agree, please add your votes!

Comments (9)
Wouter's profile image Profile Picture

J. Burke on 05 Jul 2020 23:14:03

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

We'd like to see this as well. On a report or dashboard that is shared through the app or embedded in a SharePoint communication site, it'd sure be nice if reports would show the information that user has been given access to. For example, it'd be best if a project manager of one job is looking at a SharePoint page that has a report that shows revenue, fee, status of a company's projects, instead of all the projects having to be shown, it'd be great if only the project that user is associated with are shown. Otherwise, we'd have to spin up a separate SharePoint site for each project, and create a filter for each PowerBI report. Managing a few core reports and some form of a user access / permissions module sounds administratively more feasible than having to manage a ton of manually filtered reports. To add to that, managing a permission filter by user, role or group would be ideal.

Wouter's profile image Profile Picture

Omer on 05 Jul 2020 22:56:07

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

Original idea could be resolved by row level security in some scenarios. The part I would like to vote is the ability to hide/show filter pane and to give developers the option to set page/report level filters' visibility.

Wouter's profile image Profile Picture

Power BI User on 05 Jul 2020 22:31:47

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

In my case I have 1 dataset on sales. They want to analyse closed salesorders on one page and open salesorders on another page. When using a page level filter to distinguish open of closed salesorders, the end user is able to alter the filter. This is not what we want. This filter should be fixed in reading mode.

Wouter's profile image Profile Picture

Power BI User on 05 Jul 2020 22:29:55

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

Although a lot of the examples provided are covered by Row level security, I would still like a way to not allow Object/Chart filtering, so that I can set a visual level filter and users cannot change it.

Wouter's profile image Profile Picture

Joe Natarajan on 05 Jul 2020 22:16:21

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

We have a similar situation mentioned by Quiten. We need to create a standard dashboard for 50 leaders and they should only be able to see the data only for their individual teams. Thanks Power BI team

Wouter's profile image Profile Picture

Jeremy on 05 Jul 2020 22:12:57

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

I agree as well. Same as Quinten. I'm going to create a dashboard to 20 agents to check their own statistics and I don't want them to check their colleagues :)

Wouter's profile image Profile Picture

Quinten Questel on 05 Jul 2020 22:12:40

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

I agree... I am pushing the dashboard to 50 different agents and i do not want them to she the other agents reports or filter to show all agents. This would be a fantastic feature.

Wouter's profile image Profile Picture

Francois Huard on 05 Jul 2020 22:03:45

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

At the dataset level would be great. This way all level of visualization apply the same filtering

Wouter's profile image Profile Picture

Arup Chatterjee on 05 Jul 2020 22:02:27

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

Page filter in reports with option to be hidden from users (other than owner) would be great addition.

For eg.
My report had multiple page filter to arrive at correct data for that page objects.. Some filter I want user to change.. some should be restricted (only owner can view and/or change)