Format time/date on X-Axis

[Anonymous]

Hi - Power BI Community!

I want to show only 2019 October as 2019.10 or 10.2019 (no day)

or

only once 2019 and once 2020 - not at the beginning of all months.

I tried to change the date/time format but nothing has change I use the dax: 

Dates = CALENDAR(DATE(2019,09,30),TODAY()) with hierachie. 

Thank you for your time.

[amitchandak · Accepted solution]

@Anonymous , Create a month year column and sort on month year sort column

Month Year = format([Date],"mm.yyyy")

or

Month Year = format([Date],"yyyy.mm")

sort on

Month Year sort = format([Date],"yyyymm")

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[themistoklis]

@Anonymous 

You can convert datetime to Year-Month using the following formula:

Year-Month  = FORMAT('Table'[Date], "yyyy.mm")

OR 

Year-Month  = FORMAT('Table'[Date], "mm.yyyy")

OR

Year-Month = ( YEAR('Table'[Date])*100+MONTH('Table'[Date]) )

Then add it to axis