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

Question

1.40K viewsJuly 1, 2021

0

ColeenB 4 Posted July 10, 2020

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 July 1, 2021

2 Answers

Daparpon · Answer 1 · 2021-07-01T09:06:27+00:00

0

Daparpon 7 Posted July 1, 2021 0 Comments

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

Thanks in advance.

Daparpon Answered question July 1, 2021

habeebR · Answer 2 · 2020-07-13T09:03:33+00:00

0

habeebR 125 Posted July 13, 2020 0 Comments

Hi Coleen,
can you share the pbix file.

habeebR Answered question July 13, 2020

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

2 Answers

Questions

UsersView all users