Switch Hierarchies based on Slicer

[joshua1990]

Hi experts!

is there any way to switch between hierarchies using a slicer?

Article

Hierarchy 1.1

Hierarchy 1.2

Hierarchy 2.1

Hierarchy 2.2

I would like to put this hierarchy in matrix (row).

1. 1. Hierarchy
   1. 2 Hierarchy
2. 1 Hierarchy

[Anonymous]

Hi @joshua1990 ,

Has this problem been solved? If you have solved it, you can post your solution here. If any of the responses were helpful to you, please consider marking them as solutions, which will help more users find similar problems faster. If the problem is not solved, please feel free to let us know. Thanks in advance!

Best Regards,
Gao
Community Support Team

[Anonymous · Accepted solution]

Hi @joshua1990 ,

Try using bookmarks and filters together.

The PBIX file is attached for reference.

Best Regards,
Gao
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!

How to get your questions answered quickly -- How to provide sample data

[otravers]

Try field parameters:

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

[joshua1990]

@otravers : Thanks! Are you shure field parameters works with hierarchies?

[otravers]

They work with individual dimensions within hierarchies, now that you ask I'm not sure you can switch entire hierarchies in one click which I guess is what you're really going for. That's an interesting use case!