Forum Discussion

deepu299's avatar
deepu299
Icon for Advocate V rankAdvocate V
8 years ago

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

    • deepu299's avatar
      deepu299
      Icon for Advocate V rankAdvocate V

      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.