How to change date display format of Month/Year on Chart X-Axis

[Anonymous]

I have chart that I want to change the Y-Axis format that is currently reading as "2019 - January" to "01/19" How would I do that? It's coming from my date table.

[amitchandak]

In your date table you can create a new column

Month year = format([Date],"MM-YY")

But this will not sort correctly

So, create sort Column

Month year sort= format([Date],"YYMM") and mark this as sort column of the first one an then use the first one.

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

I am hosting a webinar on 25th April on Power BI, Check Details - https://www.linkedin.com/posts/amitchandak78_webinar-tech-techforgood-activity-6658266754378231808-y...

[th3h0bb5]

Honestly your best bet is to use a proper Date Table that has a MonthNum column and something like ShortYear as well.

If you're unable to do that, you can create three calculated columns to get a very close approximation of what you want.

MonthNum = MONTH( 'Table'[Date])

YearShort = RIGHT(YEAR(Table[Date]),2)

Month Year = Sales[Month] & "/" & Sales[YearShort]