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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
deepu299
Advocate V
Advocate V

Hierarchy slicer multi selects automatically

Hi @jppp

 

I am using the hierarchy slicer, it works great but has some limitations which you will get in later releases when Power BI API supports custom visuals. I have an issue here if its a known one and provide me some help: 

 

I am using this for text column. On one of the columns when I select a particular value it auto selectes the next hierarchy as well. It works fine with other values though. When tried to uncheck the whole dashboards fails with the error. Here are the details: 

 

Feedback Type:
Frown (Error)

Release:
August, 2018

Product Version:
2.61.5192.601 (18.08) (x64)

Error Message:
Invalid or malformed QueryDefinition

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461814]

IE Version:
11.0.9600.19100

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

AS Live Connection:
True

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_newFromWeb
CustomConnectors
PBI_variationUIChange
PBI_canvasTooltips
PBI_showIncrementalRefreshPolicy
PBI_compositeModels

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_PythonSupportEnabled
PBI_DB2DQ

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @deepu299

Though I are not able to reproduce your problem, in IE or chrome, I found an similar issue, could you have a look at it and try the methods?

 

Best Regrads

Maggie

Hi Maggie @v-juanli-msft , Thanks for your response. I tried turning off both select all and empty Leaves. I have 3 levels of hierarchy and I have 2nd & 3rd level matching in 2 leaves. I am not sure if this is the cause. Something like below: 

 

1ResearchSC Research
2ResearchResearch
3ResearchResearch

 

when I select Research hierarchy, it selects SC Research hierarchy as well. If I try to uncheck Research hierarchy, it doesn't uncheck the other one and throws an error. When I select SC Research, the same beahvior doesn't repeat. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors