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 Accoun...
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?
Hi Andregewehr,
Thanks for looking into it.
Here is the expected results in
Daily Sales in Q4 - Dec-Oct:
ID Account Name City State Total Sales 12/31/2022 12/30/2022 12/29/2022 10/1/2022 1 A TX 300 100 200 2
B PA 900 200 700 3 C OK 800 300 500 Weekly Sales in Q4 (start of the week):
ID Account Name City State Total Sales 26-12-2022 19-12-2022 12/12/2022 1 A TX 300 2
B PA 900 3 C OK 800 Monthly Sales in Q4
ID Account Name City State Total Sales Dec Nov Oct 1 A TX 300 100 200 2
B PA 900 200 700 3 C OK 800 300 500
