Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
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.

BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
1 year ago

Hello Syndicate_Admin 
As per you use case If you're using only month values then you can just change your column value format like below attached image and order the Fecha column by Orden column
Note : You should change the Orden column datatype to Whole Number

 

Thanks & Regard...