CODEWITHSUNDEEP
powerbi
kazzi
kazzi

Reputation: 534

Date Column in Power BI spiting into 4 columns

I'm using Power BI, pulling data from a SQL server, but for a column containing date, it keeps splitting into 4 other columns when I try and show it in a table:

Year | Quarter | Month | Day

Has anyone had this issue before?

Note: Under modeling, when selecting that field I did try placing Data Type as Date. No change.

Upvotes: 1

Views: 560

Answers (1)

Andrey Nikolov
Andrey Nikolov

Reputation: 13460

This is because Power BI made a date hierarchy from this field. If you do not want this, right click it in the designer and uncheck Date hierarchy (select Date) from the menu: enter image description here

Upvotes: 2

Related Questions