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...
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])

     

     

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
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])