Hide column based on RLS

[obriaincian]

Hi All,

Appologies for posting again but I cannot find a solid solution.

I have a matrix in Power BI something like the below

Workstream	Employees	Platfrom 1	Platform 2	Platform 3	Platform 4
A	4	1	5	4	5
B	20	5	5	5	5
C	10	4	5	6	4

Note that columns Platform 1 - Platform 4 are all calulated measures that contain the count of employees for that specific platform (it's a simple measure with a filter per platform).

My Issue

I have RLS on the data table that filters the data on the company of the user. Based on the company I want to show/hide columns Platform 1 - Platform 4.

So lets say the user works for company x then they should only see Platform 1,

If the User works for company x & y they should see Platfrom 1 & 2 but not 3 & 4.

Can someone let me know if this is possible?

[amitchandak]

@obriaincian , OLS can do, but it will error.

With userprincipalname()  you can make value blank for measures

If(userprincipalname() = "Abc@abc.com", [M1], blank())

or

If(userprincipalname() = "Abc@abc.com", [M1],[M2])

you can check a table

If(userprincipalname() in  values(Table[Email]),   [M1],[M2])