Forum Discussion
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.
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
12 Replies
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
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.
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 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
