Filtering multiple graphs/tables simultaniously

[TomOerlemans]

I have been attempting to solve this for a couple of days now, unfortunately I am a complete noob at power BI and I feel like I still don’t know where to start, and if this is even possible. Any help is therefore very much appreciated.

To illustrate my problem I have created a toy problem, which is the following:

Table 1: Total

Date	Revenue
Jan 2018	1200
Feb 2018	1500
Mar 2018	1500

Table 2: Product

Date	Product	Revenue
Jan 2018	0	500
Jan 2018	1	700
Feb 2018	0	700
Feb 2018	1	800
Mar 2018	0	800
Mar 2018	1	700

Table 3: Manager

Date	Manager	Revenue
Jan 2018	a	300
Jan 2018	b	700
Jan 2018	c	200
Feb 2018	a	350
Feb 2018	b	650
Feb 2018	c	500
Mar 2018	a	400
Mar 2018	b	600
Mar 2018	c	500

My task is to create a meaningful dashboard with this data. And one of the main goals is to be able to use those categorical variables (i.e. manager and product) as filters.

So for example, I'd like to create something like this:

And when I click on one of the categories inside of the bottom two bar graphs, foe example on manager 'c', I' d like to see the top graph (the line graph) adjust as well. Is this possible? Or is there a better way to deal with this kind of data?

(P.s. This is a toy problem, the actual dataset has 7 categorical variables, which all have a lot more categories (500+) than shown in this example).

[ryan_mayu]

Creating a dimension table date which including a column month(e.g. Jan, Feb...) without duplicated value. linking this table to all tables' month column to  create the relationship.

[v-piga-msft]

Hi @TomOerlemans,

If you want to have the interaction between the graphs/tables, you should create the relationships between the tables.

However, for your scenario, it seems that we should create the relationship with the key Revenue. However, we cannot create the relationship with the Revenue. We only could create the relationship with Date, but that is not your requirement.

You may should have a good look at create relationship.

Best  Regards,

Cherry

[TomOerlemans]

Alternative approaches in dealing with this kind of problem are appreciated as well..