Field Parameters and Hierarchy: Can you filter on each hierarchy and modify the order it displays?

[deeave]

 I created a Hierarchy and field parameter to present the 6 slicers.  When clicking on the slicers, it modifies the data below. Works great!  I have two questions: 

1. How do I filter on individual hierarchies?  Example, for Active, only show active. When I apply to this visual or the whole page, it doesn't show all the data.  Would a measure work in this case?
2. How do I change the order of the slicer?  I'd rather have it as Ideation, Discovery, Pending Start, Active, Paused, Closed.  Is this possible?  Another measure?  I tried sorting under Model View, but wasn't provided an option to manual select the way I wanted the items sorted.

[Anonymous]

Hi @deeave ,

A ragged hierarchy is also created when there are blank values for a category at any hierarchy level. For example, if Employee A has three levels of management (manager > vice-president > CEO) but doesn't have a "director", the data table row for Employee A will have three values (names) and one blank. While you can use the Filters pane to deselect blank values for "director", doing so also prevents the other three values from being included in the slicer for Employee A. As a result, Employee A will be removed from the hierarchy slicer.

Add multiple fields to a hierarchy slicer - Power BI | Microsoft Learn

You need to create a column with sorting order, and then sort your category by this column.

Solved: Change chiclet slicer order - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[deeave]

I created a field parameter (dynamic hierarchy)  and modified to look like the first attachment.  This creates a slicer with 6 buttons.  When I click on the buttons, the data in the table populates below.  My challenge is two things that I'm not sure are possible.

1. Can you apply a filter based on the button you select?  Right now, when I apply a filter, it applies to the whole table.  Should I be using a different visual to display the data? 
   • For example, if I select Ideation, I only want to show those that are not promoted to discovery. Currently applying this filter results in the data being blank when other slicer buttons are selected.
2. Ability to change the colors of each button within the slicer (I think I found a workaround to this, so not a priority) - you can't change the colors, but you can put the colors next to the slicer.

This is the hiearchy I created with the Field Parameter option.

These are the slicers that I would LOVE to color like the ones above and sort, but I don't see any option to do so while using the dynamic hiearchy.  I am aware how to do it in the values, but when the Dynamic Hiearchy is added, it only adds the Value4 (groups) and you cannot sort inside.

[Idrissshatila]

Hello @deeave ,

You need to sort by column to have it with the order you want.

i recommend this video, it will help https://youtu.be/nWgPynP9XDM?si=TqzqkSNguYxvM8UA

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡