Sorting Quarter with Multi selection of Fiscal Year

[Anonymous]

Hi Folks,

Please help me with below issue:

If I select only one fiscal year then Quarter are showing up in correct order:

But if I select 2 Years then it is not coming in correct order.

Here I need ,  Q1-JAS-2019, Q2-OND2019, Q3-JFM-2020, Q4-AMJ-2020, Q1-JAS-2020,Q2-OND-2020 order.

I am using sort by column method  but it fails when it comes to multiple selection in Fiscal year.

Kindly Help!

[amitchandak · Accepted solution]

@Anonymous , You have to mark Sorting Quarter as the sort column for Quarter Year

refer for steps https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

@amitchandak , I have done that but it's not working with slicers when I am selecting more than 1 year in year slicers.

Sort by column is working only when 1 Year is selected in Fiscal year Slicer.  (I have used Sorting Quarter to Sort it)

[amitchandak]

@Anonymous , looking at Sorting Quarter, it should work fine  across year.

You have selected column "Quarter Year" and then from menu click on sort by column and selected  Sorting Quarter

and your visual is sorted on "Quarter Year" (option under 3 dots)