sort by field value in decending order

[Anupal]

Hello Friends,

I need to sort my matrix in decending Order by field(Product) value.

Current Setup
	Product
Account Name	END POINTS	HYBRID	SAAS
AAAAAA	88888	55555	22222
BBBBBB	77777	44444	111111
CCCCCC	66666	33333	0
Expected Sorting(Decending)
	Product
Account Name	SAAS	HYBRID	END POINTS
AAAAAA	22222	55555	888888
BBBBBB	111111	44444	777777
CCCCCC	0	33333	666666

How can I do that?

Thanks

AP

[johnbasha33]

@Anupal create another sort column

[v-yiruan-msft · Accepted solution]

Hi @Anupal ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create a product sort dimension table just as below screenshot and sort the column [Product] by the field [Sort]

2. Create the measures as below

Measure = 
VAR _product=SELECTEDVALUE('Sort'[Product])
RETURN CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Product]=_product))

Sum of value = SUMX(VALUES('Sort'[Product]),[Measure])

3. Create a matrix visual (Rows: [Account Name]  Columns: [Product] of dimension table  Values: [Sum of value])

In addition, you can refer the following blog to get it.

Sort a Column with a Custom Order in Power BI - RADACAD

Best Regards

[Anupal]

Updating the details-

Current Setup
	Product
Account Name	END POINTS	SAAS
AAAAAA	88888	22222
BBBBBB	77777	111111
CCCCCC	66666	0
Expected Sorting(Decending)
	Product
Account Name	SAAS	END POINTS
AAAAAA	22222	888888
BBBBBB	111111	777777
CCCCCC	0	666666