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.
When using row level security and using a dynamic title it does not update the title based on the filter set in RLS.
It only updates if I click on the filter used in the title even though it is only showing 1 selection that should appear in the title
Solved! Go to Solution.
Hi @CEllis ,
This is the interface for RLS to select roles, it can't function as a slicer or a filter.
RLS is just a row level security, it just hides the parts that should not be seen and only shows the visible rows, it does not do any filtering. This DAX of yours needs to be in place for the filtering to take effect.
In addition, RLS will only change the contents of the dataset, and will not change the display of such things as titles, legends, axis names, etc., which are not part of the dataset. If you want to use this DAX of yours for dynamic transformation of Title, create slicer or use filter.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@CEllis ,
can you explain more and show us what are you using.
Please share sample data in a usable format (not screenshots) that fully addresses your issue or question.
Avoid including sensitive info or unrelated content. Need help uploading data? Visit https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Show what you expect based on the provided data.
For faster answers, see https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Proud to be a Super User! | |
Hi @Idrissshatila ,
Using the DAX as apose to the field doesnt change the text from 'ALL School' to 'School 2' when using one ofthe roles.
VAR ConCat =
CALCULATE (
CONCATENATEX (
VALUES ( 'Table'[Name] ),
'Table'[Name],
", "
)
)
VAR IsItFiltered =
IF ( ISFILTERED ( 'Table'[Name] ), ConCat, "ALL Schools" )
RETURN
IsItFiltered
Hi @CEllis ,
This is the interface for RLS to select roles, it can't function as a slicer or a filter.
RLS is just a row level security, it just hides the parts that should not be seen and only shows the visible rows, it does not do any filtering. This DAX of yours needs to be in place for the filtering to take effect.
In addition, RLS will only change the contents of the dataset, and will not change the display of such things as titles, legends, axis names, etc., which are not part of the dataset. If you want to use this DAX of yours for dynamic transformation of Title, create slicer or use filter.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |