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)

bhanu_gautam's avatar
bhanu_gautam
Super User
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)

  • 123abc's avatar
    123abc
    Community Champion
    3 months ago

    what a excellent solution. Thank you so mcuh. its solved my many issues.😍