Forum Discussion
Creating Hierarchy Slicer for Bar Chart with Field Parameters
Hi AFriendlyMonkey ,
First, make sure that the hierarchical relationships between Loc1, ID1, and ID2 are properly defined in the data model.
Since in Power BI Desktop, dates are automatically created in the hierarchy, the rest may need to be set up by you according to your needs.
You can refer to this step by step:
1. Select More Options on the right side of Loc and then select Create hierarchy.
2. Select More Options on the right side of ID1 and ID2 and then select Add to hierarchy and then select the hierarchy you just created.
Second, instead of using a standard slicer with field parameters, consider using a hierarchy slicer.
Hierarchy slicers allow you to visualize and navigate hierarchical data more intuitively.
You can create a hierarchical slicer by adding fields (Loc, ID1, ID2) to the slicer visual object and arranging them in hierarchical order.
For more information about the Hierarchy Slicer, see the following documentation:
Add multiple fields to a hierarchy slicer - Power BI | Microsoft Learn
If you have any further questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
This solution does not produce the slicer I want. When I follow your instructions I end up with a slicer like this:
The variable in my y-axis is a measure, so I want it to summarize the information at either a Field, ID1, or ID2 level. With the slicer you made, the user can select specific fields, but it still must also show ID1 and ID2 with the field.
I would rather the slicer appear like this (the one made with the tutorial):
So I want the user to choose the lowest level of the hierarchy that the graph displays. For example, if ID1 is chosen, I want it to still show the field as well:
Because the IDs can repeat on different fields, it is useless to summarize to only ID1 or ID2. The best solution I found was simulating a hierarchy with a dynamic slicer, but this seems to only show the lowest level and is described by the problem in the past sentence.
If there is a solution to choose the level of hierarchy displayed with a slicer, that would be perfect.
