Sorting Matrix Table Values

[Raul09]

Hi,

Let's say i run a company with 3 sales teams,. i want to create a matrix table that shows the sales amounts by channel and product.

Something like this

#	Product A	Product B	Product C	Others	Total
Sales Team 1	$             500	$             750	$             950	$         1.500	$         3.700
Reps	$             250	$             610	$             630	$         2.100	$         3.590
Telephone	$             300	$             256	$             456	$         5.000	$         6.012
Total	$         1.050	$         1.616	$         2.036	$         8.600	$       13.302

I have 10 products, but i don't want 10 columns, i want to show the top 3 sellers (PRODUCT A,B AND C) and group the other 7 products in "Others" column.

how can i acomplish that?

Thanks in advance.

Best Regards.

[CahabaData]

2 questions

Is the structure of the data set already in side by side, or is it a stacked normalized table?  perhaps a few rows in example could help

Are you intending that PBI determine the top 3 - or - do you know what they are and manually creating the visual?

[Raul09]

I will manually select my top 3 products to show and the others 7 to group too.

Example Data:

Document No	Order Date	Customer	Rep Code	Quantity	Amount	Product	Channel
1	5/3/2017	X	A1	500	$       15.000	A	Sales Team 1
2	5/3/2017	G	S2	400	$       32.000	B	Distributors
3	5/3/2017	B	D3	100	$         5.600	X	Telephone
4	5/3/2017	N	D3	200	$       58.000	Y	Sales Team 1
#	Product A	Product B	Product C	Others	Total
Sales Team 1	$       15.000	$                  -	$                  -	$       58.000	$       73.000
Distributos	$                  -	$       32.000	$                  -	$                  -	$       32.000
Telephone	$                  -	$                  -	$                  -	$         5.600	$         5.600
Total	$       15.000	$       32.000	$                  -	$       63.600	$    110.600

[Anonymous · Accepted solution]

Hi @Raul09，

In your scenario, you can right click Product in the Fields panel and select “New Group”, then create Product group and drag the Product group to Columns in Matrix visual, this way, you will get expected result. For more details, please review the following screenshots.

Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-grouping-and-binning/

Thanks,
Lydia Zhang

[Raul09]

Solved! Thanks 😄

Now, how can i sort the column order by amount?

it shows alphabetically..

Best Regards.

[Anonymous]

---

@Raul09 wrote:

Solved! Thanks 😄

Now, how can i sort the column order by amount?

it shows alphabetically..

Best Regards.

---

Hi @Raul09,

Since this thread is closed, please open a new thread about this new issue. Our engineers will give response to you in the new thread.

Thanks,
Lydia Zhang