Forum Discussion
year format
If you need to sort the data my the month and year, you can create a new calculated field.
month-year = format([month],"00")&"-"&[Year]
Hi NirH,
In Power BI, it’s impossible to set a year column to 'Date' type in “yyyy” format. If you change a column with just years into date type format, it will format your data into a date.
Why does it do this? Well, it's probably because there is really no reason to convert years to a Date field anyway. It doesn't give you any extra functionality or anything. You can use the year field however you want (as a filter, in a visual, in a measure) WITHOUT it being in Date format!
My suggestion: leave the column in whole number / integer format.
Hope this helps.
Ganesh
If you need to sort the data my the month and year, you can create a new calculated field.
month-year = format([month],"00")&"-"&[Year]