Descending sort financial year - matrix visual

DAX DAX Calculations
1

Hi everyone, I have this measure that sorts the month & year in financial starting july (ascending order)…now, how can I sort it in descending order in matrix visual as it doesn’t show up the month & year in columns? Thanks in advance :slight_smile:

Month Financial Year Sort =
IF (
    MONTH ( Dates[Date] ) > 6,
    MONTH ( Dates[Date] ) - 6,
    MONTH ( Dates[Date] ) + 6
)

image
image856×428 30.8 KB

2

@ronald_balza - I recently find out that you can add a sorting measure in table (and matrix) and hide that column. There was also another trick.

I will try some links.

1 Like
3

@ronald_balza - and here is also a link :

If you will use it all the time that kind of sort - it’s better to set this in model view (you can set up for Month&Year Sort by column which you want):

image
image293×967 12.1 KB

There is also Brian’s technique:

Hope it helps.

Best regars

4

Hi @mspanic, thanks for taking the time on this. Appreciated it :slight_smile: Unfortunately, none of it works on my usecase. I able to sort them by a measure already. However, couldn’t find a workaround on how to sort it by descending if that makes sense. Cheers :slight_smile:

1 Like
5

@ronald_balza - maybe if you provide some pbix sample with the problem, will be much easier to find proper solution.

6

Found this solution on the web and it worked on my usecase

Monthly Sort Descending =
RANKX ( VALUES ( 'DataTable'[Date] ), 'DataTable'[Date],, DESC )
1 Like