Slicer and Roles

[alv_ibar_123]

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

[v-ljerr-msft · Accepted solution]

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. 

Regards