Forum Discussion
Report Level Filters' Sequence
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
Hi Anonymous,
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.
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 Anonymous,
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.
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.