Disable button based on button text

Question

Hi,&nbsp;&nbsp;I'm trying to disable a button when Button Text displays "View Restricted".&nbsp;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."&nbsp;&nbsp;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.&nbsp;&nbsp;Is this possible?&nbsp;

allisonkennedy · Answer

You could try this using a workaround similar to this method described here, by using the 'drilllthrough' functionality for your button rather than 'page navigation' and adding a visual that the user has to click to enable the button. Choose or configure the data so that only non-restricted users see the visual that needs selected before they can navigate:
https://www.linkedin.com/pulse/adding-password-box-power-bi-report-wyn-hopkins/

anonymous · Answer

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?

allisonkennedy · Answer

Not yet, you could vote for it on ideas.powerbi.com

anonymous · Answer

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!&nbsp;

anonymous · Answer

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")

2. On a standard button, choose Page Navigation as the type

3. In the Destination field, use the measure.

You can do the same thing on the button text, obviously with a different measure.

In the action feature of a standard button, choose Page Navigation.

Forum Discussion

Disable button based on button text

5 Replies

Related content

Button

Button Slicer - State disabled

Buttons

Disabling buttons for conditions.

Navigation Buttons Missing