Forum Discussion
Slicer and Roles
I have a data from a school for teachers and directors from 1st to 4th grade.
I have 3 levels of hierarchy in the same filter, where I am grouping the data in the tables as appropriate.
_All = 1 ° + 2 ° + 3 ° + 4 °
1 ° = 1 ° A + 1 ° B
2 ° = 2 ° A + 2 ° B
3 ° = 3 ° A + 3 ° B
4 ° = 4 ° A + 4 ° B
the roles were created in the following way:
1 level: access full: "_All" || "1 °" || "1 ° A" || "1 ° B" || "2 °" ..... etc
2 level: medium access: "1 °" || "1 ° A" || "1 B"
3 level a: low access: "1 ° A"
3 level b: low access: "1 ° B"
But I need the 1 level to enter and only the "_All" filter is active and the other filters are visible but not active
For the second filter I need that this active only "1 °" and the filters "1 ° A" and "1 ° B" are visible but not active.
Help please
Hi alv_ibar_123,
But I need the 1 level to enter and only the "_All" filter is active and the other filters are visible but not active
For the second filter I need that this active only "1 °" and the filters "1 ° A" and "1 ° B" are visible but not active.
I don't think there is an option to do it in Power BI currently. You can add it as an idea on Power BI Ideas to improve Power BI on this feature. :smileyhappy:
Regards
1 Reply
- v-ljerr-msftMicrosoft Employee
Hi alv_ibar_123,
But I need the 1 level to enter and only the "_All" filter is active and the other filters are visible but not active
For the second filter I need that this active only "1 °" and the filters "1 ° A" and "1 ° B" are visible but not active.
I don't think there is an option to do it in Power BI currently. You can add it as an idea on Power BI Ideas to improve Power BI on this feature. :smileyhappy:
Regards