Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Automatic grouping by dates

Hello,

I'm new to Power BI.

I looking for a reason why Power BI dose not create automatic grouping by dates. 

I have dates formated as date and when I am draging "date" into axis it do not give me grouping by quaters, months. 

Data are taken from SQL server. 

I would like to ask you for advise with this. 

 

 

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    I suggest to create caculated columns as below and add them as a hierarchy manually to work around.

    Year = YEAR('Product'[SalesDate])
    Q = "Q" &QUARTER('Product'[SalesDate])
    Month = MONTH('Product'[SalesDate])
    day = DAY('Product'[SalesDate])

     

     

     

4 Replies