Sort Martix by column

Question

I'm currently using the sort option to organize data, but it's sorting based on the values across all months. Instead, I want to sort data by the selected month specifically. For example, if I select January and sort in descending order, it should display values like 29508, 20484, 17844, 10368, etc. Similarly, if I select February and sort, it should show 29748, 10596, 9684, 9468, etc.

Is there a way to achieve this?

rajendraongole1 · Accepted Answer

Hi&nbsp;Evelyn_L&nbsp;-&nbsp;Use below measure to sort the value dynamically as per selection of month:&nbsp;Here i have a seperate date table connected to my financial table date column ,&nbsp;&nbsp;Measure:&nbsp;SelectedMonthValue =VAR SelectedMonth = SELECTEDVALUE('DateTable'[Month])RETURN&nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; SUM(financials[Profit]),&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; financials,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FORMAT(financials[Date], "mmmm") = SelectedMonth&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )&nbsp;&nbsp;sort the matrix visual with selectdmonthvalue&nbsp;it works. please check&nbsp;Did I answer your question? Mark my post as a solution! This will help others on the forum!Appreciate your Kudos!!&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Sort Martix by column

1 Reply

Related content

Sort by another column

Column Chart sorting

Sorting

Table Sort , sort order , comparer

sorting matrix