Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago
Solved

Sort Custom Date Column in Array

Good morning I want to make a matrix where the data of a date column ordered by fiscal year is shown, that is, the first month is April, May, June, etc. I tried sorting the date column by a custom ...
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    Hi Syndicate_Admin,

    Thank you for sharing the sample data.


    Here I Created a Month Order table, establish a relationship with the main data table, and replace the existing month field in the matrix visual with the new one from the Month Order table.

    i'm sharing the Measure:

    MonthOrderTable =
    DATATABLE(
        "Mes", STRING,
        "FiscalMonthOrder", INTEGER,
        "MonthNumber", INTEGER,
        {
            {"abril", 1, 4},
            {"mayo", 2, 5},
            {"junio", 3, 6},
            {"julio", 4, 7},
            {"agosto", 5, 8},
            {"septiembre", 6, 9},
            {"octubre", 7, 10},
            {"noviembre", 8, 11},
            {"diciembre", 9, 12},
            {"enero", 10, 1},
            {"febrero", 11, 2},
            {"marzo", 12, 3}
        }
    )


    I'm sharing the .pbix file for the reference.

    If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

     

    Thank you for using Microsoft Fabric Community Forum.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago

Thank you so much for the reply, but it didn't work for me.

The Order column is set as an integer and the date column is set as a date, I sort it according to the Order column, but it doesn't work for me.

I leave a screenshot, (how can I attach the pbix file?)

Best regards

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

Hi Syndicate_Admin,

 

To Attach the Pbix.file just go to the reply option and click on it you will see the browse option as below screenshot. 
Here you can attach the file.

 



Thank you.