Visual filter works on table but doesn't on bar chart count

[Fátima]

Hi!

I have been all morning trying to understand what is happening here, and I don't get it. It'll probably be some little detail that I am missing, all help is appreciated!

I attach a wetransfer with the pbix, so you can test it out if you need it (you can ignore the blue graph): https://we.tl/t-JcCC6k7cGr

I have two tables as follows:

FORMS

ID     ID_CENTRE    DATE

1       1                    01/01/2022

2       1                    03/01/2022

3       2                    01/01/2022

FORMS_ANSWERS

FORM_ID      QUESTION                      ANSWER      IS_CHECKED

1                   What do you do?            Work            TRUE

1                   What do you do?            Study           FALSE

1                   Are you happy?               Yes               TRUE

1                   Are you happy?               No               FALSE

2                   What do you do?            Work            TRUE

2                   What do you do?            Study           FALSE

2                   Are you happy?               Yes               FALSE

2                   Are you happy?               No               TRUE

3                   What do you do?            Work            FALSE

3                   What do you do?            Study           TRUE

3                   Are you happy?               Yes               TRUE

3                   Are you happy?               No               FALSE

I am creating a bar chart to show the count of each answer (just the ones that are checked), but just of the last forms of each centre. So with the data above, if I am not filtering by date, I should show the answers of the forms with ID 2 and 3. If I filter by DATE <= 02/01/2022, I should show the answers of the forms with ID 1 and 3.

I have created a measure on the table FORMS, isActiveBoolean, that returns 1 for the forms that I have to show.

If I set a visual filter for the table to only display the ones where isActiveBoolean=1, it works. But if I set it on the bar chart, it doesn't, it shows the count of the answers of the three forms.

Why is it not filtering on the bar chart by "isActiveBoolean"? The "IS_CHECKED" filter is working fine, am I missing something?

Regards!!

[Pragati11 · Accepted solution]

HI @Fátima ,

Just checked your file and it seems like everything is working fine.

Make sure to understand there is a difference on your table visual & bar chart.

1. Table visual has a FORM ID column which filters with other information when you slice the date slicer.
2. Bar Chart hasn't got a FORM ID column in it. It just shows the count of answers. So when you slice using date filter, bar chart filters, but as there is no FORM ID column a confusion creates.

To test this, I moved FORM ID on the x-axis of your bar chart and it seems to shoe the right results.

Now when you start using the DATE slicer, the form Id values seems to be aligning on your table visual & bar chart as shown below:

I see the same FORM ID values in your table visual & bar chart here.

I think you need to work on presenting the information some how so it doesn't create confusion.

[Fátima]

Thank you so much, @Pragati11 ! With your explanation, I managed to create the bar chart as I needed.

Regards!

[Pragati11]

HI @Fátima ,

Glad to know that you have a solution now 🙂