How Can I see only own information and other information should be hidden

[Anonymous]

In the above image when ever user is "Json Adams" is loged in into the PowerBI that time "Json Adams" he can see his information. other employee name should be hidden but total value it will show.
How Can I achive this one.

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

If you want to display the Total in a card visual, you can configure the RLS first, then create a new table to get the Total value.

And you can add this value to a card table.

Create a Total value table.

Total = SUMMARIZE('Fact','Fact'[Values])

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BTW, pbix as attached.

[Anonymous]

@Anonymous 

Use RLS for that.

use below link for more details: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#:~:text=Row-level%20security%20(RLS)%20with%20Power%20BI%20can%20be,can%20define%20filters%20within%20roles.&text=You%20can%20configure%20RLS%20for,BI%20with%20Power%20BI%20Desktop.

[Anonymous]

I tryed with Row level Security But not able to achive this function.
Only one data I can see at a time.

[Anonymous]

Step 1. you should have one column with email id or userprinciplename() who logs in to the report.
Step 2. From the Modeling tab, select Manage Roles.

Select Manage Roles

From the Manage roles window, select Create.

Under Roles, provide a name for the role.

Under Tables, select the table to which you want to apply a DAX rule.

In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example:
[Email]= userprincipalname()