Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to sort fiscal quarters

Good morning,    So I have a calendar table which includes fiscal quarters. I have names them in the following format Q1 2017, Q2 2017...  However, when I use them in a visual I want them to sort ...
Need Help
  • tarunsingla's avatar
    tarunsingla
    7 years ago

    Creating the column with Year and Quarter (like "2018 Q4") would be ideal. But if you wish to see your data in Quarter Year format, you can use the Sort By Another Column feature of Power BI. Have both YearQuarter and QuarterYear columns and then select the QuarterYear field, go to Modeling tab, under Sort By, pick YearQuarter. That will sort QuarterYear by YearQuarter now.

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous

Not necessarily. You can create an additional column with the order in which you want the quarters shown and use the 'Sort by Column' feature. Or use one of the existing column for the ordering if you already have a valid one.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I am not sure I follow this. If I look at my calendar table it is currently sorted in the order that I would want to see but that doesn't translate to how it is presented in a visual...