Forum Discussion

IzakVA's avatar
IzakVA
Regular Visitor
1 year ago

PBI Row Level Security and State-wide view

My app shows the state-wide data if a Ministry of Health (MOH) user is logged in and only the relevant Local Health District's (LHD) data if an LHD user is logged in. See the screen shots below. MOH...
Need Help
IzakVA's avatar
IzakVA
Regular Visitor
1 year ago

Hi Neeko Anonymous 

Yes, I would like to have the LHD user view the state-wide data view and have only the Relevant LHD name available in the LHD slicer as a filter option. If the LHD is selected, only the LHD's data should be displayed. If unselected, the state-wide data should be displayed. Is this possible?

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi IzakVA ,

 

We need to prepare a separate table of state-wide data. There is no model relationship between this table and other tables.

 

Places the District column of the state-wide table on the table visual object.

New roles.

View as:

If anything is unclear to you, please refer to my pbix file.

 

Best Regards,

Neeko Tang

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

  • IzakVA's avatar
    IzakVA
    Regular Visitor
    1 year ago

    Thanks for your quick reply. I don't think this will work for me, since I have a data model with many tables and 21 report pages with visuals that all need to work off the slicers. I can't duplicate the whole data model. Thanks for the suggestion.