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.
Hi fizzslash ,
Could you please tell us that if your problem has been solved?
If so, please accept the helpful reply as solution. More people will benefit from it.
If not, please provide us with more detailed information, thanks.
Best Regards,
Stephen Tao