Sort the chart by Quarter - year

[vipin_jha123]

I have created a chart report in Power BI , Now I want to display the result in sorted by quarter-year like 

Q2-2017 Q1-2017 Q4-2016 Q3-2016 Q2-2016 Q1-2016 AND SO ON

[dipen007]

Hi,

I would like to sort my column clustered chart by Q'YY.

I have by QTR display column which contains data from Q1'15 to Q3'17, when I create a column chart, the bar chart is showing in the following order Q1'15, Q1'16, Q1'17, Q2'15, Q2'16, Q2'17 and so on..

My requirement is to have a column chart is in order, for example Q1'15, Q2'15, Q3'15, Q4'15, Q1'16 and so on..

How do I achieve it? Please help.

[Eric_Zhang · Accepted solution]

---

@vipin_jha123 wrote:

I have created a chart report in Power BI , Now I want to display the result in sorted by quarter-year like 

Q2-2017 Q1-2017 Q4-2016 Q3-2016 Q2-2016 Q1-2016 AND SO ON

---

@vipin_jha123

For Date, you can expand the date hierarchy to Quarter level. As to more general custom sorting, you can watch this video Sort By Another Column.