Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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
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.
I tryed with Row level Security But not able to achive this function.
Only one data I can see at a time.
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()
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |