Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Hi, @Anonymous
Can you explain what it means? I don't understand what's your problem.
In this link we are talking about a single button with slicer but my requirement is one button per page
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |