cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

How to filter a chart based on multiple table relationships?

Hey All,

 

I'm new to Power BI and was wondering how i could create multiple relationships between 2 tables. My data model looks like this

JoelAndrews_1-1605276119963.png

 

I have a chart created (incorrect because of relationships) and want to display Total Users and Users from the Traffic Data table but be able to filter by Value_Prop field that exists in both tables. I've used the Value_prop field from the Txn Data table as the primary filter as it filters other charts in the dashboard.

 

JoelAndrews_2-1605276337259.png

 

How can i filter the above chart on both the Date from the calendar table and Value_Prop from Txn Data table with measures from Traffic Data table?
 

3 REPLIES 3
Community Support
Community Support

Hi @JoelAndrews ,

 

You have got the correct result, haven't you?

v-lionel-msft_0-1606806929397.png

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Community Support
Community Support

Hi @JoelAndrews ,

 

v-lionel-msft_0-1605513355701.png

You need to replace [Users] and [Total Users] with meatures and complete the correct aggregation by adding filters in the measures.

Do you mind sharing your .pbix file? If yes, please show the sample data.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hey! 

You can access the files here: https://drive.google.com/drive/folders/1WECvC7FofNZLCiDBq4IH54fQK8WOOhg3?usp=sharing

 

I've created the visual. I want to filter the chart on both the Date from the calendar table and Value_Prop from Txn Data table with measures from Traffic Data table.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors