Forum Discussion
Solution SageIssues with HierarchySlicer when using field parameters and measure for sorting as values
hi, mariussve1
Using values you can (pre)filter the hierarchy to show only members with values. Typical scenario: Filtering a product/category hierarchy with sales. Values are not displayed in the visual.
You can change the indicator as shown below:
According to your example pbix, the result is as follows.
hackcrr
If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly
Memorable Memberhi, mariussve1
Using values you can (pre)filter the hierarchy to show only members with values. Typical scenario: Filtering a product/category hierarchy with sales. Values are not displayed in the visual.
You can change the indicator as shown below:
According to your example pbix, the result is as follows.
hackcrr
If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly
Solution SageHi hackcrr,
Thank you so much for your response. Does this mean that I CANNOT use values to create a measure to sort the membership list? My membership list can have a different number of customers, and I want the member with the most customers to be at the top of the list. Currently, it is sorted alphabetically instead.
Can values ONLY be used to filter the list?
BR
Marius 🙂
- hackcrr
Hi, mariussve1
Yes. The value of this slicer if row=1 as you described at the beginning, then your visual object will not show any data:
row=1 did not find any matches in your parameter. You can check out the profile of the author of this visual object:
https://azurebi-docs.jppp.org/powerbi-visuals/hierarchy-slicer.html?tabs=docs%2Cdocs-open
hackcrr
If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly