Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Hierarchy support in slicer issue

Submitted by Anonymous on ‎02-25-2020 12:30 AM

Hi,

 

I have a peculiar bug to report.

 

Issue: The hierarchy feature in the slicer visual is available in Power BI even though the preview fearture "Hierarchy slicer" is not checked.

 

Why this is a problem: Using a hierarchy in the slicer without enabling the preview feature is buggy. The main problem here is that the collapse/expand generates an error message.

 

Effect: This will create a lot of issues for users that start using this feature without knowing about the preview feature setting. This buggy setup does not encourage Power BI usage among common users.

 

Suggested solution: Do not show heirarchy in slicer visual unless the preview feature is enabled. (I.e. show it like it was before this feature was added).

 

Image showing: Using hierarchy in slicer without enabling the preview feature "Hierarchy slicer".

image.png
Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎02-26-2020 12:57 AM

Hi @Anonymous, 

 

Which Power BI desktop version do you run? 

 

Based on my test in Power BI desktop version 2.78.5740.861 64-bit (February 2020), if the Hierarchy Slicer preview feature is not enabled, we can only drag one field to the slicer so there is no expand/collapse button.  Please run the same desktop version as ours then test again. 

 

Best Regards,
Qiuyun Yu

Anonymous
Not applicable
‎02-26-2020 01:42 AM

Hi Qiuyun,

 

Capture.PNG

 

It seems I run the same version. I created the Hierarchy in Power BI by simple drag and drop. I recreated the issue in a different setup with import from an SQL database. (Se image below)

 

BUT, I might have found out why you could not recreate it. Try the following steps to recreate:

 

1. Drag the dimension hierarchy into the blank "drawing surface" so that it by default creates a table.

2. Having the table visual, containing the hierarchy, selected click the slicer visual icon to turn it into a slicer.

3. See the slicer showing your hierarchy expanded by default.

4. Generate the error by trying to collapse the slicer hierarchy

(Tell me if I should add pictures of the steps if you cannot recreate it)

 

Thanks!

/Hannes

 

Image: A new setup testet with the sames result.

Capture2.PNG

 

Idea Statuses