Forum Discussion
Drill through based on User Logged In
Hello rohit1991 , danextian , v-aatheeque , lbendlin , pbiuseruk
appologize for late responce.
1. Conditional Visibility on buttons (or any other visuals in PBI) will NOT work because this feature is not available at the moment in PBI. I searched for this option but not available.This Conditional Visibility on any visul is a good to have feature but PBI dont have it 😠correct me if am wrong!
2. Duplicating same report for diff users is not a viable option.
I achieved Conditional Drill through by creating User Access table (with user email and access true or fales) and 2 measure (one is identifying the user is authorized or unauthorized. and second is based on the access assigning the respective pages).
Hello,
like lbendlin mentioned - there isn't an actual feature which supports the functionality you mentioned.
However, you could make 2 reports to cater for the 2 different user groups. Not an ideal solution but it would work.
Also, you could play around with bookmarks and make 2 of the visuals on a single page which requires the drill throughs to separate pages. You could make an instruction note and button at the top to toggle the bookmarks, which would show/hide the visuals. You'd need to make it so that the visual would break, if the user hasn't got the right permission and then the instruction would tell them to click the bookmark button, to toggle the other visual. Again, this isn't ideal but it's a workaround.