Filter Order is not as expected.

[Anonymous]

Hi All,

I have created simple Report using Power BI Desktop.

and the report is having 3 filters 1. FiscalMOnthNumber 2. FIscalQuarter and 3.FIscalYear

The Current order of filter is :

1.FiscalMOnthNumber
2.FiscalQuarter
3.FiscalYear

The Expected order of filter is:

1.FiscalYear
2.FiscalQuarter
3.FiscalMOnthNumber

Kindly request you to help me on this.

Thanks in advance. 

[affan · Accepted solution]

@Anonymous

You are right that it rearranges the order. I think you can acheive this through a little trick if feasible for you.

Just rename the columns as A.FiscalYear , B.Quarter & C.Month

Hope this would resolve your issue. 

Regards

Affan