topic Re: Problem with visual filter on multiple tables in Desktop

Problem with visual filter on multiple tables

PowerBiNovice99 — Fri, 02 Mar 2018 11:35:07 GMT

I have a report that has three different data tables.

Within the main table there are individual transactions that all have a category A and B. Multiples transactions for each category.

I have two secondary tables that additional information on category A and B and again multiple records for each category.

I have created two additional tables that give me unique values for all the items in category A and B

Everything correctly connects up in the relationship manager.

I have cards that apply visual totals to the transactions from the main table when the user selects either something from category A or B in other visuals. These are all based off the main table.

I have tried to add cards that give a single number based on data in other tables. However this card only shows the total rather than filtering based on the selection of category A or B.

I would like this to change based on what the user has selected in other visuals

Re: Problem with visual filter on multiple tables

PowerBiNovice99 — Fri, 02 Mar 2018 10:00:35 GMT

Re: Problem with visual filter on multiple tables

PowerBiNovice99 — Fri, 02 Mar 2018 10:08:24 GMT

Re: Problem with visual filter on multiple tables

BalaVenuGopal — Fri, 02 Mar 2018 12:42:02 GMT

Hi PowerBiNovice99 ,

Could you pleae provide data diagram with example what you need

Re: Problem with visual filter on multiple tables

PowerBiNovice99 — Fri, 02 Mar 2018 16:43:42 GMT

[img]https://preview.ibb.co/c4HYCn/PowerBI.png[/img]

Re: Problem with visual filter on multiple tables

PowerBiNovice99 — Fri, 02 Mar 2018 19:16:37 GMT

Sorry should have said that most of my visuals are based on the table cc_data and trying to get a card that sums the relevant categories from the table target based on what has been selected in the other visuals

Re: Problem with visual filter on multiple tables

Anonymous — Tue, 06 Mar 2018 07:17:06 GMT

PowerBiNovice99,

Please check the following steps to troubleshoot this issue.

1. Change the Cross filter direction ftom Single to Both between TARGETS table and Brokers table.

2. Click other visual, enable "Edit interactions" , then make sure that you choose Filter for the Card visual.

If the above steps don't help, please share dummy data of your table and post expected result.

Regards,
Lydia