Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
TomOerlemans
New Member

Filtering multiple graphs/tables simultaniously

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:

toy_dashboard.png


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).

3 REPLIES 3
ryan_mayu
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




v-piga-msft
Resident Rockstar
Resident Rockstar

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
TomOerlemans
New Member

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.