Forum Discussion

fizzslash's avatar
fizzslash
Regular Visitor
1 year ago
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...
Need Help
  • pbiuseruk's avatar
    pbiuseruk
    1 year ago

    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.

pbiuseruk's avatar
pbiuseruk
Resolver IV
1 year ago

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.