Forum Discussion

alv_ibar_123's avatar
alv_ibar_123
Frequent Visitor
8 years ago
Solved

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-msft's avatar
    v-ljerr-msft
    Microsoft 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