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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.