Hide columns

[diogovaz]

Hello,

There is a way to hide columns based on groups? It means, if someone of Sales Department go see the report they can't see the column X but if someone of board access to the report they can see column X.

Thanks for your help in advance,

Diogo

[v-yuezhe-msft]

@diogovaz,

What I can think of is to create two reports for the two groups. In one report, right click the column X in your table and select Hide, this report if for Sales Department. Another report that doesn't hide column X is for board department.

Regards,
Lydia

[Greg_Deckler]

Never tried to do exactly that but you might investigate row level security (RLS) as that is the only way that I could think of that would handle that kind of thing.