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.

tarunsingla's avatar
tarunsingla
Icon for Solution Sage rankSolution Sage
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.