cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RajSaha20
New Member

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

PowerBI.png
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.


1 ACCEPTED SOLUTION
v-zhenbw-msft
Community Support
Community Support

Hi @RajSaha20 ,

 

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])

 

howcan1.jpg

 

howcan2.jpg

 

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.

View solution in original post

4 REPLIES 4
v-zhenbw-msft
Community Support
Community Support

Hi @RajSaha20 ,

 

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])

 

howcan1.jpg

 

howcan2.jpg

 

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.

View solution in original post

Anonymous
Not applicable

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

RajSaha20_0-1600019501248.png

 

Anonymous
Not applicable

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()

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.