Forum Discussion

spagad6263's avatar
spagad6263
Icon for Post Patron rankPost Patron
4 years ago
Solved

How to stop Date Hierachy?

I've just added a date field to Matrix, and it automatically convert to hierachy format as Year >> Quarter >> Month >> Day. I only would like to show as [Year Month], so how this be done? Thanks. Bel...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi spagad6263 

    create a new column

    YearMonth = YEAR ( TableName[Date] ) * 100 + MONTH ( TableName[Date] ) 

    then use it in the visual 

  • MahyarTF's avatar
    MahyarTF
    4 years ago

    Hi,

    Add new Column to your table that is indicated the YearMonth as below :

    Year-Month = FORMAT([Date],"YYYYMM")
    Then use it in your Visual.
    You could use one of the below format for your column 
    YYYYMM : 202209
    YYYYMMM : 2022Sep
    YYYYMMMM : 2022September
    YYYY-MMMM : 2022-September
    ...
spagad6263's avatar
spagad6263
Icon for Post Patron rankPost Patron
4 years ago

Thanks for the quick reply.