Hierarchical Filter – Other Visuals Won’t Load when Hide Blanks is selected

2.10K views
0

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

2 Answers

0
7 0 Comments

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

Thanks in advance.

Answered question
0
175 0 Comments

Hi Coleen,
can you share the pbix file.

Answered question
599 Questions total questions asked
294 Solved total solved questions
561 Answers total answer posted
1222 Total users total community members