Forum Discussion
Solved
Date not populating
Hello, My date field is syncing to a date in the paginated report (see screenshot), but when I add it to a report, it is not showing as a date and I do not have the auto year/quater/month/week op...
Agree with lbendlin but if for some reason you really want that as part of that column, you can do this:
Go into Power Query and make the Month, Quarter, Year fields by clicking on the add column tab and selecting the date dropdown and then selecting the above mentioned things.
Then when you load this into your Power BI report, you can select these columns in the field pane and make a heirarchy.
Strongly suggest to just make your own calendar table though and do it that way.
and I do not have the auto year/quater/month/week optionsGood - you don't want these anyway. Use your own calendar table in your data model. No need for extra hierarchies.
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?