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).
Hi PremK
Add a slicer button to the main page and synch it with the drillthrough page. Then, create a measure to use as a visual-level filter for the visuals on the drillthrough page.
IF (
SELECTEDVALUE ( 'table'[button value] ) = "Logged in user",
CALCULATE (
COUNTROWS ( users ),
KEEPFILTERS ( user[user email] = USERPRINCIPALNAME () )
)
)
visual level filter on this measure = not blank.
Hi PremK ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Thank you.
Hi PremK ,
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi PremK ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!