cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
balakrishna141 Regular Visitor
Regular Visitor

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
affan Established Member
Established Member

Re: Filter Order is not as expected.

@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

Highlighted
Community Support Team
Community Support Team

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

10 REPLIES 10
affan Established Member
Established Member

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

 

balakrishna141 Regular Visitor
Regular Visitor

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

 

 

Omega Established Member
Established Member

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

balakrishna141 Regular Visitor
Regular Visitor

Re: Filter Order is not as expected.

Hi Omega,

 

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

affan Established Member
Established Member

Re: Filter Order is not as expected.

@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

 

affan Established Member
Established Member

Re: Filter Order is not as expected.

@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

balakrishna141 Regular Visitor
Regular Visitor

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 Team
Community Support Team

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

balakrishna141 Regular Visitor
Regular Visitor

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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 351 members 3,338 guests
Please welcome our newest community members: