Forum Discussion

kumsha1's avatar
kumsha1
Icon for Post Patron rankPost Patron
6 years ago

Individual buttons for multiple slicer values

Hi,

 

We are trying to implement page-lvel security based on user login, so that only relevant pages of the report are available for access.

Ex: User A login can only see report pages XY3, XY4.

Till here it's working fine and the table returns data as below. Now the requirement is to call these values into individual buttons to enable navigation for the user. Can someone pls help with how to create measures for this.

Ex: For above user A, there will be buttons XY1, XY2. If another user has access to 3 pages, then the buttons should dynamically change to XY1, XY3 and XY4...

 

Page NameOrder
XY11
XY22
XY33
XY44

 

Followed below link to create a slicer and then button value change based on slicer selection. But the requirement is now to have direct buttons, so that users don thave to select the slicer values.

https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-power-bi/