Cross-filtering not working with Dimension control

[mathatalmd]

Hey,

tl;dr: when using a Dimension control on a table, the cross-filtering filter remains empty.

Context

I have setup an example report that makes use of Dimension Control to update the displayed dimension in my Table A. When selecting a row in Table A to cross-filter for, the cross-filtering filter does not populate itself with any data.

Below is an example of cross-filtering filters working as intended, with a Table B not making use of Dimension Control.

Is this is known bug or am I missing something here?

Let me know if I should provide further information.

Thank you!

[sam8]

I’m trying to reproduce the issue here, but it seems to work okay for me. Maybe I’m not reproducing your issue properly?

It looks to me like when I toggle a dimension control, it clears the existing filters. But then when you click a row in the table, the cross filtering works as expected. Do I have that right?

[mathatalmd]

Hey @sam8,

thanks for looking into this, indeed you are not reproducing the issue exactly as I presented and in your case it works.

To replicate my case, can you remove the "Users city” dimension from your table? When doing so, then my use case is replicable.

I believe your case works well because the table is filtering on the static “Users city” dimension and not the dynamic one coming from the filter.
When a table’s dimension solely comes from the dynamic dimension coming from the Dimension control then the filter does not update

[sam8]

Ah, thanks for the guidance. I think I’m closer to replicating the issue, check this out:

First image, no filter.

Second image: I cross filter on Users City, but then a filter populates for Users State. This seems like incorrect behavior, but it isn’t exactly what you reported. It sounds like in your case the filter just fails to populate at all?

[mathatalmd]

Indeed my case is a bit different since, to reuse your example, I attempt to filter on Users city and when doing so the filter remains empty.

I managed to identify why you are unable to replicate my issue 1-to-1. To correct that, please keep only 1 dimension in your table (say Users City). Then select a dimension using Dimension Control (you can also select Users City, behaviour remains the same) and the filter will remain empty.

Here is a step by step example with my data:

1. For the initial setup, have a table with only 1 dimension

2. Select a dimension using Dimension Control and cross filter for that dimension. Filter is not populated

Hope that helps you replicating, let me know

[sam8]

Look at that- I managed to replicate it. The filter appears in the filter bar, but it just says “Cross filter -”.

Thanks so much for your help and patience! I will report this to the team, and I’ll let you know if there are any workarounds or fixes.

[mathatalmd]

Thanks Sam for looking into this, please keep me posted