Date not populating

[fizzslash]

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 options. Can someone help? Am pulling the data in through api calls on make.com to a semantic table.

Thanks!

[v-stephen-msft]

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

[pbiuseruk · Accepted solution]

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.

[lbendlin]

and I do not have the auto year/quater/month/week options

Good - 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?