How to decide column visibility based on user role?

[vipinkmathews]

I have a Sales Report table visual with 10 columns and few of them are numeric columns.

For example : Product Code, Prod Name, Description, Unit Price, Qty, Discount %, Total Sales

I am publishing this report to PBI service and I create a dashboard and pin this report page.

My requirement is to hide the columns - Discount %, Total Sales for all the users except Managers.

I.e. For a sales person it will hide these 2 columns and if the logged in user is a manager then it will display all the columns.

Q 1: How to create users under 2 new groups(Manager Group & Sales Group) so that it's easy to specify these group of users while sharing a dashboard rather than adding individual users?

Q2 : When the manager level users and sales person level users are added to the dashboard users list, how do it hide/show the column visibility in the dashboard for the above mentioned columns?

Q3 : The same visibility should be applied to the report as well.

Kindly let me know the feasible approach.

Best Regards

Vipin

[Seth_C_Bauer]

@vipinkmathews You can't perform column level permissioning in Power BI. The Row Level Security filters the entire dataset not specific visibility in visuals or columns. You could control whether or not the data shows up, but all end users would see the same column headings. The idea is here, you could vote for it.

[vipinkmathews]

@Seth_C_BauerIf this basic feature is not available, is there any other alternative to toggle the visibility of the column?

Any DAX formula can help on this?

Best Regards

Vipin