How to hide visual for specific users

[TusharGaurav]

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 view only pie chart and line chart but not the matrix.

Can we achieve the same in power bi?

Thanks and Regards,

Tushar Gaurav

[DineshYadl]

Hi @TusharGaurav 

By using RLS you can hide visual for specific users. With the help of USERNAME() DAX function. This function will capture the domain and username from the credentials given to the system at connection time.

DAX syantax 

username= IF(CONTAINS(UsersTable,UsersTable[login], USERNAME()), "Allowed", BLANK())

In model view ---> Manage roles ---> create Role (User) with the help of USERNAME() DAX function

For data validation click on View as --> select the "User" role 

It will restrict the data based on the domain name and username of the system.

Thanks 

[TusharGaurav]

Thanks for your response.

Can you please share the pbix file on tushargaurav1@gmail.com.

It will be helpful

[Deku]

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

[bhanu_gautam · Accepted solution]

@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() = "specificuser@domain.com", 0, 1)