cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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. 

 

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: Filter Order is not as expected.

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

 

Regards

Affan

View solution in original post

Highlighted
Community Support
Community Support

Re: Filter Order is not as expected.

hi, @Anonymous

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

10 REPLIES 10
Highlighted
Solution Sage
Solution Sage

Re: Filter Order is not as expected.

Hi @Anonymous

 

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

 

Highlighted
Anonymous
Not applicable

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

 

 

Highlighted
Post Prodigy
Post Prodigy

Re: Filter Order is not as expected.

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

Highlighted
Anonymous
Not applicable

Re: Filter Order is not as expected.

Hi Omega,

 

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

Highlighted
Solution Sage
Solution Sage

Re: Filter Order is not as expected.

@Anonymous

 

 

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

 

Highlighted
Solution Sage
Solution Sage

Re: Filter Order is not as expected.

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

 

Regards

Affan

View solution in original post

Highlighted
Anonymous
Not applicable

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.

Highlighted
Community Support
Community Support

Re: Filter Order is not as expected.

hi, @Anonymous

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

Highlighted
Anonymous
Not applicable

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 .

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors