Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
Hi,
I'm trying to disable a button when Button Text displays "View Restricted".
Right now, my button text is formulated so it displays either "view restricted" or "click to view report" based on their userprincipalname. So for example, if user A is eligible to view, when user A sees the welcome page, he will see "Click to View Report"; if user B's not eligible, then user B sees "View Restricted."
I want the button to navigate me to another tab (named Home) when it says "Click to View Report" but when it says "View Restricted" I want the button to be disabled.
Is this possible?
I know this is rather late, but you can do the disabling without needing to do the drill-down functionality.
1. Create a measure with a conditional check -
Destination_Page = IF(ISFILTERED('Table'[Location]),"Page 2")In the action feature of a standard button, choose Page Navigation.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
I am trying to avoid drillthrough function because there is nothing to be selected to trigger the drillthrough. The report is pulling who is viewing the report by userprincipalname function, which then changes the button text to either restricted or click to view data.
Is there not a way to reach a solution by keeping navigation button (and making the button have multiple functions depending on button text) instead of changing it to drillthorugh?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hmm. Then is there a way to use drillthrough without having to make any selection? I need users to be able to see the whole page as long as they have the credential to (from the front page usernameprincipal function to read who is viewing it). The website you gave me earlier needs users to put in username and password, but I want to make this as simple as possible. Thank you for that solution though, I will definitely use it if drillthrough without selection doesn't work!
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 78 | |
| 46 | |
| 37 | |
| 31 | |
| 26 |