Forum Discussion

jonbox's avatar
jonbox
Icon for Helper II rankHelper II
4 years ago

bar graph by quarter

Hi,

 

I'm creating a bar graph using the quarter heriarchy for date, changing from all months to just quarter, however PowerBI seems to be mixing up the quarters:

 

it's calculating the quaters correctly for Actual Prediction (our finanical year starts in July) e.g.

July, August, Septermber quarter = 2.1

October november december = 2.7

January February March = 10.7

 

 

The problem is with the ordering of the quarters, e.g. Qtr 3 should be Qtr 1, Qtr 4 should be Qtr 2, Qtr 1 should be Q3 etc...

 

Firstly how can i get the PowerBI to order the quarters correctly?

Seconly how can i edit the Quarter names to show more relevant names e.g. change Quarter 1 to be called July August September or JAS?

 

 

Any help on this would be appreciated!! Thank you!

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    jonbox , You can create a column like

    and use that

    if(Quarter([Date])>=3, "Qtr " & Quarter([Date]) -2, "Qtr " & Quarter([Date]) +2)

     

    or create a sort column using the logic and user that as sort column

    • jonbox's avatar
      jonbox
      Icon for Helper II rankHelper II
      4 years ago

      A column like what sorry?

       

      I'd like to use this default feature if possible as the data will change month on month, e.g. once we roll into the new year we won't be interested in the quarters before