Power Up Program - Introduction to the Power Pl...

Build a Power BI report to visualize tasks - Demo

(2) Share

Report

Posted on by Layan Jwei

Hi,

When transforming the "jobs" excel into power BI:

1. In the video "DueDateTime" in query editor was converted to Date only and it appeared as DD MM yyyy
but when i did it, it appeared as MM DD yyyy -- why?

2. After applying the query editor, if we look at table view, the due date started showing days like this. why?

3. in visualizations, when i did it, due date time appears divided like this

but in the video it appeared normally, why??

Categories:

General Discussion

All responses (3)

Answers (0)

Layan Jwei 12 on at

Like (0)

Report

Build a Power BI report to visualize tasks - Demo

Hi w.p,

Thanks a lot for your help

1. Where is this setting in the power query editor? i tried to switch this between united states and united kingdom but it didn't work

2. There is no column tools in the report view, I think you mean the table view. I was able to find it thank you it worked

3. It works thank you
Suggested answer

w.p 1,657 on at

Like (0)

Report

Build a Power BI report to visualize tasks - Demo

@Layan Jwei

1-It's based on the user's machine local region setting in the Power Query.
2-It's a default setting. In the report view, you can change the date format in the Column tools ribbon.
3-Another BI default setting called Time Intelligence can be turned off via File, Options, Current File, Data Load, Time Intelligence: Auto Date/Time.

That one's just a demo, you're not expected to follow along.
Michael E. Gernaey 38,788 Super User 2025 Season 1 on at

Like (0)

Report

Build a Power BI report to visualize tasks - Demo

hi @Layan Jwei

In your excitement you forgot to post your actual transformation expressions.