Forum Discussion

TusharGaurav's avatar
TusharGaurav
Helper III
1 year ago
Solved

How to hide visual for specific users

Hi Expert,   In my report page, there are 1 pie chart, 1 line chart and 1 matrix. I need to hide the matrix for a specific user, so that when he access the report from power bi service, he can vie...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    TusharGaurav  You can use RLS
    Go to the "Modeling" tab.
    Click on "Manage Roles."
    Create a new role and define the DAX filter that will be used to control access.

     

    Publish your report to Power BI Service.
    Go to the dataset settings in Power BI Service.
    Click on "Security."
    Assign users to the roles you created.

     

    Use the DAX filter to control the visibility of the matrix visual. You can create a measure that returns a value based on the user's role and use this measure to control the visibility of the matrix.

    IsMatrixVisible = IF(USERPRINCIPALNAME() = "[email protected]", 0, 1)

Deku's avatar
Deku
Super User
1 year ago

I think the best you can do is row level security, but the user will get a error on the matrix, rather than it being hidden. I assume the reason for hiding is security related.

 

If you had a app then you could think about audiences, with a secure report and a more general report