Dynamic binning in a matrix visual

[Anonymous]

I have a table which has list of all employees along with their supervisor. I am trying to create binning / grouping for no. of people under each supervisor. For ex, if there are 4 supervisors managing 19 people, supervisor 1 can have 5 people reporting and some other can have only 2 people reporting. Sup 1 will come in group "5-7" reports and the other can be grouped under "1-2". However, these groups may change when certain filters are selected say a particular division or a region is selected for the employees given that a supervisor can have reports from different divisons/regions. 

If i use a calculated column to create this group based on no of reports, the filters will not work and if I use a measure, then the matrix visual in Power BI will not take it as an input for a column in the matrix.

Refer to this Sample excel sheet for some understanding if it helps.

[Anonymous]

https://docs.google.com/spreadsheets/d/1sKbtid3xnNolv__z5iHREW3PwllmZTl_/edit?usp=sharing&ouid=11800... 

Can you see if this google sheets link is working? I guess I did not enable "anyone with link can access"

[Anonymous]

Hi @Anonymous,

We are unable to view the excel example you provided because we do not have access.

Please see if this cases are help here .

If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any confidential Information.

Article for reference:How to provide sample data in the Power BI Forum 

Hope it helps,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

If more details or clarity is needed please let me know. Would really appreciate some help/feedback on this.