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?

Answered question

Hi! I’m having the exact same problem. How did you solve it?

Thanks in advance.

Answered question
You are viewing 1 out of 2 answers, click here to view all answers.