Forum Discussion
Marix Visual - Sorting by desc order
I have a requirement where I am using Matrix visual, I have to show column total on left side and most recent date on left (Descending order). Is there is way to achieve this?
Data:
| ID | Account Name | City | State | Sales | Invoice date |
| 1 | A | TX | 100 | 1/24/2023 | |
2 | B | PA | 200 | 2/25/2023 | |
| 3 | C | OK | 300 | 1/24/2023 | |
| 4 | c | OK | 500 | 2/25/2023 | |
| 5 | B | PA | 700 | 3/26/2023 | |
| 6 | A | TX | 200 | 2/25/2023 |
Expected table :
| ID | Account Name | City | State | Total Sales | Mar | Feb | Jan |
| 1 | A | TX | 300 | 100 | 200 | ||
2 | B | PA | 900 | 200 | 700 | ||
| 3 | C | OK | 800 | 300 | 500 |
4 Replies
Hello,
Have you tried to make a measure using filter by month? I think you can use these measures:
Sum Sales Jan = CALCULATE(Sum('Table'[Sales]), MONTH('Table'[Invoice date])=1) Sum Sales Fev = CALCULATE(Sum('Table'[Sales]), MONTH('Table'[Invoice date])=2) Sum Sales Mar = CALCULATE(Sum('Table'[Sales]), MONTH('Table'[Invoice date])=3)But I think your expected table gives wrong numbers, check it. I guess you should expect this:
Thank you for your quick response.
Sorry for not mentioning it earlier, I have to show daily, weekly and Monthly report separately. How can I show daily sales (365 days) in descending order (most recent date in left to right)?
Can you show the expected results you want?
