PBI RS Jan 2021: Microsoft Native Hierarchy Slicer with Search Option Issue
Submitted byAnonymouson08-04-202110:07 AM
Currently we are using the January 2021 PBI RS native Microsoft slicer using the hierarchy functionality (adding multiple columns as layers). In the process have also turned on the "Search" capability. When using the search option, it narrows down the selection in any level of the hierarchy. Example: Searching for the word "Ford" would look at both the Vehicle and Brand column as pictured below. It then narrows down the selection to only showing items with "Ford".
Now, if there are many different versions of the word Ford the list starts to become large. You then think that when selecting the level above it > Cars, as a fast route instead of selecting each individual version of Ford, you would only get a count with what you searched for originally.
That is not the case. You are actually getting that level that you clicked on, count of Cars regardless of the brand (in this example 6 instead of desired 3). Ideally if you are using a search option and only seeing results for that lowest level, you would want a way to quickly select those options without having to individually click on them. Actual Behavior:
Expected Behavior: (notice I had to select each individual lowest level option to get the count)