Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi Everyone,
Is it possible to automatically expand a hierarchy slicer when searching for something?
As of now it looks like each time i m searching for something i manually need to expand all levels in order to correctly slice the "fact" table.
Screenshot1: Selecting the highest level of granularity of a slicer with a search value -> Fact table not properly filtered (expecting only one value)
Screenshot2: Selecting the lowest level of granularity of a slicer (manually expanded all levels) with a search value -> Fact table correctly filtered (expecting only one value)
Best,
Kevin
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 68 | |
| 46 | |
| 44 | |
| 29 | |
| 20 |
| User | Count |
|---|---|
| 202 | |
| 130 | |
| 102 | |
| 71 | |
| 55 |