Paramaters with Different Level of Hierarchies

[Anonymous]

Hello Community!

How to set up a paramater that would consist of different layers of hierarchies (used in a pivot table but also in visualizations)? 

I want the user to be able to choose between the level of hierarchy they wish to display. 

Many thanks

[ray_aramburo · Accepted solution]

Sorry if my answer seems ambiguous, by the way you phrased your question I would assume you already know how to create hierarchies within Power BI and how to create parameters as well. This is the process:

1. Go to Model view and right click on any field you want to bring into a hierarchy:

2. After its creation you'll see the hierarchy icon and on the pane on the left, add the second level of Hierarchy through the dropdown list:

3. Repeat 1 & 2 as needed to create the hierarchies with different levels

4. Now you have 2 alternatives for achieving what you want: 

Create a pivot visual per Hierarchy and show/hide them through Bookmarks.

4a.

4b. 

Repeat this to show/hide the other visual.

4c. Add a bookmark navigator

4d. Now you can switch along bookmarks and hierarchies:

Option 2:

4.1 Create a field parameter containing all the levels of hiearchies you would like to include:

4.2 Create your pivot adding the Parameter created to the Rows

4.3 Through the parameter slicer you can control which fields to show and in which order

I hope this now answers your question. I have attached a sample file for you to view what's in the screenshots.

[Anonymous · Accepted solution]

Hi @Anonymous 

Thank you very much N0EL and ray_aramburo for your prompt reply.

I found your question while checking forum posts. Did you solve your problem? If not, here are some ideas I can offer.

Here's some dummy data

In the Modeling tab, click New Parameter.

Add column options (e.g. Country, State, City).

Drag a slicer visualization to the report and add parameter fields to the slicer. And display data using parameter fields.

The user can select the hierarchy level to be displayed through the slicer.

Here is the result.

Regards,

Nono Chen

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

[N0EL]

Hey @Anonymous,

If the example below looks similar to what you're looking for, @parry2k has a wonderful video on his YouTube channel detailing how to accomplish this along with a link to his sample pbix file imaged below.  Have a good one!

Video Link:  https://www.youtube.com/watch?v=xjBVKLn5fzs

[ray_aramburo]

Create multiple hierarchies and then create a parameter that contains the different hierarchies.

[Anonymous]

@ray_aramburo I'm sorry but this is a waste of time for both of us. Obviously I wouldn't ask had I known how to do it and you answer says literally nothing. 

[ray_aramburo · Accepted solution]

Sorry if my answer seems ambiguous, by the way you phrased your question I would assume you already know how to create hierarchies within Power BI and how to create parameters as well. This is the process:

1. Go to Model view and right click on any field you want to bring into a hierarchy:

2. After its creation you'll see the hierarchy icon and on the pane on the left, add the second level of Hierarchy through the dropdown list:

3. Repeat 1 & 2 as needed to create the hierarchies with different levels

4. Now you have 2 alternatives for achieving what you want: 

Create a pivot visual per Hierarchy and show/hide them through Bookmarks.

4a.

4b. 

Repeat this to show/hide the other visual.

4c. Add a bookmark navigator

4d. Now you can switch along bookmarks and hierarchies:

Option 2:

4.1 Create a field parameter containing all the levels of hiearchies you would like to include:

4.2 Create your pivot adding the Parameter created to the Rows

4.3 Through the parameter slicer you can control which fields to show and in which order

I hope this now answers your question. I have attached a sample file for you to view what's in the screenshots.