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 Coleen,
can you share the pbix file.

Answered question