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 c...
Need Help
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