Forum Discussion

Anonymous

Not applicable

5 years ago

Disable button based on button text

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" base...

Community Champion

5 years ago

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
Not applicable
5 years ago
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
  Community Champion
  5 years ago
  Not yet, you could vote for it on ideas.powerbi.com
  - Anonymous
    Not applicable
    5 years ago
    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!