How to stop Date Hierachy?

[spagad6263]

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. Below is what it shows, though I could useuse drill-down to get month info.

[tamerj1 · Accepted solution]

Hi @spagad6263 

create a new column

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

then use it in the visual 

[spagad6263]

Thanks for the quick reply.

[MahyarTF · Accepted solution]

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]

In actual fact, I just would like to show field as yyyy MMM format.

[tamerj1 · Accepted solution]

Hi @spagad6263 

create a new column

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

then use it in the visual