Dynamic tables

[hashanr]

Hi All,

I have a requirement like below, 

There is a sales person table with sales related information. Here in this table we have 4 sales person. 

Sales Person	Date	Quantity
Jack	01-06-20	10
Jack	02-06-20	20
Jack	03-06-20	30
James	04-06-20	56
Lisa	05-06-20	70
Lisa	06-06-20	20
Kim	07-06-20	100

Mainly i want to show 4 sales person information in 4 seperate tables. I can get 4 tables apply filters and achieve that. Now there is a posibility that sales person can be changed during the time. In that case we may have to change filter. 

So my question, is there any posibility that we can have dynamic tables which brakes according to no of sales person in the main table ?  I know it is possible in SSRS with grouping. I want to know how feasible is this and if so how?

I would appreciate your time to lookinto this. 

Thanks

[v-lionel-msft · Accepted solution]

Hi @hashanr ,

How about this?

Please refer to my .PBIX FILE.

Best regards,
Lionel Chen

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

[amitchandak]

@hashanr , if you want to create a table using slicer value that is not possible, then you have to explore biining and grouping. You can have a table with 4 sales person like

New table = filter(Table, Table[sales Person] in {"Jack","James","Lisa","Kim"})

Segmentation

https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/

[AllisonKennedy]

@hashanr 

I'm not 100% sure what you mean, but see if this can help: 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

You can group by bins.