Forum Discussion
Format time/date on X-Axis
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/...
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
amitchandak
Super User
Super UserAnonymous , 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