Hierarchical Filter – Other Visuals Won’t Load when Hide Blanks is selected
Hierarchical Filter works when blanks are not hidden. When I hide blanks the other visuals say
Error Message:
Encountered invalid InvalidQueryInExpression. Values is null or empty or the expression count in one list of values does not match the expression count in Expressions
I tried this with two different hierarchies, both of which work fine with the Hierarchy Slicer.
I haven’t paid for the Hierarchical Filter yet. Just testing it on Power BI desktop.
Any ideas?
Daparpon Answered question