How to decide column visibility based on user role?

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