The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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;
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:
1 | Research | SC Research |
2 | Research | Research |
3 | Research | Research |
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.