Forum Discussion
How to clean filter for unused values
Hi,
Sounds like you might need row level security.. have a look here
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/
Dave
- DeepButi8 years ago
Helper I
As far as I understand row-level security it will not provide the needed functionality.
Row-level security allow to restrict wich user can access wich data. So PowerBi user A can see only some specific values while user B can see another subset of the values.
But this is not what we are trying to obtain.
User A must be able to see alla data. User B also must be able to see all data.
When any of them looks a PowerBi chart where the SalesmanCode dimension is used we want all sales data visible ... but we want that the filter option shows only the values for which there is some fact data available, not all employee codes.
Let's put it to the maximum. There is only one sale, created obviously for only one Salesman, the fact table has just one row. The filter option still shows 200 possible values (all employees of the company). We would like the filter option showing only one value (the Salesman that created the sale).
Of course, maybe I don't fully understand row-level security :(