Continous x axis -how to change month name to number

[KristinaSp]

Hello,

Maybe someone know, how to change change chart axis (continouse type), that it would show "mm/dd" (month number/day) instead of the name of rhw month.  I need that it would be "12/04", not "December 04", Dec 04" or other ways, that shows month name.

My date column information date type is "mm/dd" (month number/day).

Thank you in advance 🙂

Kristina

[v-shex-msft]

HI @KristinaSp,
You can create calculated columns to extract the year/month/day parts from your date field and use them to create a custom hierarchy.
Then you can use this hierarchy field on your chart and it should show the effect that you wanted.
Notice: custom data healthy not same as default date field, some features not availed on it.

Regards,

Xiaoxin Sheng

[mahoneypat · Accepted solution]

Pease see this video on how to create a custom format string on a date column but have it still behave as a continous value on the axis.

Creating a simpler and chart-friendly Date table in Power BI - SQLBI

Regards,

Pat