Reply
Kevin_Conseil
Helper II
Helper II
Partially syndicated - Outbound

Automatically expand hierarchy slicer when searching for something

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)

Kevin_Conseil_0-1688483827072.png

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)

Kevin_Conseil_1-1688483855690.png

 

Best,

Kevin

0 REPLIES 0
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)