Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Preview feature - Hierarchy slicer search field

Hi,

 

first props that hierarchy is working in the slicer now!

 

If I create an hierarchy with all properties from the same table the search option is working on all levels.

if I create an hierarchy with fields from different tables (ofcourse with te correct relations) search is only working for the first level.

The slicer is working correctly and I can fix my data as a workaround.

Status: Accepted
Comments
v-qiuyu-msft
Community Support

Hi @Zeppie

 

Based on my test, it's able to filter all levels via search bar in slicer visual. Please check if the relationship cross filter direction is both. 

 

a1.PNGa2.PNG

 

Best Regards,
Qiuyun Yu

Zeppie
Regular Visitor

Hi Qiuyun Yu,

 

I created a similar testcase and I figured out what the bug is. 

First of I don't think the relationship must be both, because this is working fine:

 

working fineworking fine

 

but if i change the field 'Company' to Name search filtering is no longer working.

not working, because of same namenot working, because of same name

 

you have to really change the name of the field, changing the name in only the slicer does not do the trick.

 

Regards Zeppie

v-qiuyu-msft
Community Support

Hi @Zeppie

 

I can reproduce it now, will report it internally soon. 

 

Best Regards,
Qiuyun Yu

v-qiuyu-msft
Community Support

Hi @Zeppie

 

I have reported this issue internally: CRI 181560299. Will keep you update here once I get information. 

 

Best Regards,
Qiuyun Yu

v-qiuyu-msft
Community Support
Status changed to: Accepted
 
v-qiuyu-msft
Community Support

Hi @Zeppie

 

Will fix for May Desktop release.

 

Best Regards,
Qiuyun Yu

Zeppie
Regular Visitor

hi @v-qiuyu-msft ,

 

Awesome! Thanks for the quick support, looking forward to the update.

 

Regards,

Zeppie

v-qiuyu-msft
Community Support

Hi @Zeppie

 

Please update to May version desktop then test again: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/

 

Best Regards,
Qiuyun Yu

Zeppie
Regular Visitor

works like a charm! Thanks