Forum Discussion

CEllis's avatar
CEllis
Resolver I
2 years ago
Solved

Dynamic Title not refreshing

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 o...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

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-Forum/ba-p/963216

 

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/1447523#M607150

CEllis's avatar
CEllis
Resolver I
2 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.