Blank out values for a specific column for some user

[Rohitb]

I have a table/matrix visual where there are multiple columns some of which are measure based.

We have a scenario wherein for some set of users, we want to blank out some measure based columns and for others all columns shoukd be visible.

So how to handle this scenario?

I didnt find any way to identify in which role the logged in user maps to for me to sort this out

[NandanHegde · Accepted solution]

You can have a Security table created within the PBIX and have roles associated to that fileterd values in security table.

Post that you can compare whether that role exists within that table or not.

Attaching a sample file

[NaveenGandhi]

Hi  

Can you provide sample data and sample file if possible with a bit more explanation, As it would be easy to provide a solution.

At a first glance I can suggest you to implement RLS, But there is not specific way to hide a column from a visual dynamically.

Regards,
Naveen