Reply
Highlighted
Frequent Visitor
Posts: 9
Registered: ‎04-17-2018
Accepted Solution

Filter Order is not as expected.

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. 

 

 

 

 

 


Accepted Solutions
Established Member
Posts: 203
Registered: ‎07-12-2017

Re: Filter Order is not as expected.

[ Edited ]

@balakrishna141

 

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. Smiley Wink

 

Regards

Affan

View solution in original post

Community Support Team
Posts: 1,613
Registered: ‎07-30-2018

Re: Filter Order is not as expected.

hi, @balakrishna141

the fields in FIELDS and FILTERS are set to sort alphabetically by default. and it can be changed for now.

You could rename the fields by adding a prefix to sort them as a workaround for now.

for example:

3FiscalMOnthNumber
2FiscalQuarter
1FiscalYear

 

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Established Member
Posts: 203
Registered: ‎07-12-2017

Re: Filter Order is not as expected.

Hi @balakrishna141

 

It is not clear what you are looking for. Can you please share you pbix file if possible? or atleast a screenshot of what you are currently having on the report and how you want it to be.

 

Regards

Affan

 

Frequent Visitor
Posts: 9
Registered: ‎04-17-2018

Re: Filter Order is not as expected.

Hi Affan,

 

Thanks for your response .

i have 3 Report Level filters as mentioned above but the problem is i need to Bring FIscalYear as a first Filter.Capture.PNG

 

 

Established Member
Posts: 196
Registered: ‎05-03-2017

Re: Filter Order is not as expected.

Remove all the filters in the filter pane and re-add them in the order you want Smiley Wink

Frequent Visitor
Posts: 9
Registered: ‎04-17-2018

Re: Filter Order is not as expected.

Hi Omega,

 

Thanks you but again order is changed when close PBIX file and re open it.

Established Member
Posts: 203
Registered: ‎07-12-2017

Re: Filter Order is not as expected.

[ Edited ]

@balakrishna141

 

 

See the below illustration to acheive the result.Sort the filters.gif

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

 

Established Member
Posts: 203
Registered: ‎07-12-2017

Re: Filter Order is not as expected.

[ Edited ]

@balakrishna141

 

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. Smiley Wink

 

Regards

Affan

Frequent Visitor
Posts: 9
Registered: ‎04-17-2018

Re: Filter Order is not as expected.

Hi Affan,

 

Thank You and i can rename but user wants column names should be same as above.

Any other approach would be appriciated.

Community Support Team
Posts: 1,613
Registered: ‎07-30-2018

Re: Filter Order is not as expected.

hi, @balakrishna141

the fields in FIELDS and FILTERS are set to sort alphabetically by default. and it can be changed for now.

You could rename the fields by adding a prefix to sort them as a workaround for now.

for example:

3FiscalMOnthNumber
2FiscalQuarter
1FiscalYear

 

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 9
Registered: ‎04-17-2018

Re: Filter Order is not as expected.

Thanks Lin,

 

i have posted under Ideas section and below is the link.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36259474-filter-order-is-not-chan...

 

Please vote for this feature if it is important .