cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shubham
Helper V
Helper V

Report Level Filters' Sequence

Hi,

 

I have 3 report filters named as "Zone" -- "Region" -- "Branch". This is also a hierarchy sequence and branch is the least level.

But on Filter Section these are appearing as Branch--Region--Zone.. (by default alphabetically) 

 

Users are getting issues. They supposed to select first Zone then filtered Region and then branch .. instead of selecting branch first.

do we have any property or any work around to get rid of.

1 ACCEPTED SOLUTION
stepanpudlak
Regular Visitor

Hi there,

 

I'm using this workaround:

Instead of writing "1_" or "2_" before name of the filtered metric, use certain number of spaces (" "). The higher you need the filter, the more spaces, e.g.:

"  Zone"

" Region"

"Branch"

 

The spaces stays, but they're not shown neither on the right field menu, nor in filters.

 

The same works when you need to sort legend in visuals.

 

It's weird, but it works.

 

Štěpán

View solution in original post

12 REPLIES 12
stepanpudlak
Regular Visitor

Hi there,

 

I'm using this workaround:

Instead of writing "1_" or "2_" before name of the filtered metric, use certain number of spaces (" "). The higher you need the filter, the more spaces, e.g.:

"  Zone"

" Region"

"Branch"

 

The spaces stays, but they're not shown neither on the right field menu, nor in filters.

 

The same works when you need to sort legend in visuals.

 

It's weird, but it works.

 

Štěpán

View solution in original post

Hello,

I followd this trick and it was working fine but from few days it is not working in Power BI service. The spaces were replicating in Power BI service. Do you have any other work around for this?

 

Thanks in advance,

Srikanth

Ohhh Yes, it is working.. 

thanks for this trick..

stepanpudlak
Regular Visitor

Hi there,

 

I'm using this workaround:

Instead of writing "1_" or "2_" before name of the filtered metric, use certain number of spaces (" "). The higher you need the filter, the more spaces, e.g.:

"  Zone"

" Region"

"Branch"

 

The spaces stays, but they're not shown neither on the right field menu, nor in filters.

 

The same works when you need to sort legend in visuals.

 

It's weird, but it works.

 

Štěpán

BhaveshPatel
Community Champion
Community Champion

Hi there,

 

You can create the hierarchy in Hierarchial slicers visual that can be downloaded at PowerBI Visuals site. and then use the sync slicer functionality for mimicking report level or page level filter sync. 

 

Thanks & Regards,

Bhavesh

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

I am asking for Report Level Filter/ Page Level Filters.

Hi @Shubham,

 

Based on my tested, the filter on Report Level Filters/ Page Level Filters are not sorted by default alphabetically. If you drag a field to filters, it will display on the top, then drag another field into it, it display under the first field.

 

So in your scenairo, you can delete the fields in filter, and then dralg Zone into filter, then Region, and drag Branch into it. So it will appear as Zone--Region--Branch.
Capture.PNG

 

Regards,

Charlie Liao

@v-caliao-msft Just save it .. close it and open your .pbix file once again .. you will get alphabetically order.. or you can try after publishing it.

 

@BhaveshPatel Sir we can not drag and drop hierarchies under Report/Page level filters.

Hi @Shubham,

 

Thank you for your information, now I can reproduce this issue. It seems that this is the defaul setting in Power BI desktop. To workaround this issue, you can rename your hierarchcy name by adding a prefix to them.

Capture.PNG

 

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Charlie Liao

yep I did the same.. but it looks weird. 

Hi,

 

I have 3 report filters named as "Zone" --"Region"-- "Branch". This is also a hierarchy sequence and branch is the least level.

But on Filter Section these are appearing as Branch--Region--Zone.. (by default alphabetically) 

 

Users are getting issues. They supposed to select first Zone then filtered Region and then branch .. instead of selecting branch first.

do we have any property or any work around to get rid of.

ankitpatira
Community Champion
Community Champion

@Shubham I can reproduce your issue. I don't think currently there is a way to sort filters on the filters pane. You may have to use some alternatives such as use combination of slicers / filters, just slicers. One way I can think is to have three slicers on the report with Zone at top and have an arrow that shows next slicer and arrow to show third slicer. Also you can submit it as an idea to sort filters.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors