Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Page Level Security

I created a report with five pages and homepage with naviagtion buttons for all pages. now the recuirement is i have poeple working in differnt levels and need to give permissions accordingly.

For example

Customer- need to acess customer page

Manager- Mangement and customer page

Admin  - All Pages

I have created a security table like below

Dax query for each button

Button 1 Destination =
MAXX (
    FILTER (
        ADDCOLUMNS (
            'Page Level Security',
            "Rank", RANKX ('Page Level Security',[Order],,ASC)
        ),
        [Rank] = 1 //change this number with button number
    ),
    [Page Name]
)

Now the problem i have is, if a person  with partner acess login to the report- the button floats to the first position instead of its original positions it happens for all acess.

 

Front page view with all acess.

Front page view with partner acess

 

Is there anything else to be done to lock the position of the button. or anyother method to do page level security with multiple buttons.

 

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello Anonymous ,

    Please refer to this link.

    • Anonymous's avatar
      Anonymous
      Not applicable

      In this link we are talking about a single button with slicer but my requirement is one button per page 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support

    Hi, Anonymous 

     

    Can you explain what it means? I don't understand what's your problem.