Cross Data Filtering

[mshamsiev]

Hi everyone!

I have three separate data sources (active, closed, opened) jobs. Each one has a column which lists the Task Type (ie. incident, request etc). 

What I'm trying to do is create a Task Type filter to filter the dashboard. I have created a separate Task Type table and linked them all to the initial 3 sources. However, the filter only seems to filter one of the three data sets (active). 

Any idea how I can connect the filter to all three data sets? 

Thanks! 

Mike 

[Anonymous]

Hi @mshamsiev,

I am not able to reproduce your issue,  please help to share sample data of your tables and post a screenshot about how you create relationship among these tables.

Thanks,
Lydia Zhang

[mshamsiev · Accepted solution]

Hi @Phil_Seamark and @Anonymous,

Thanks again for the help. I ended up recreating the initial data table to overcome the issue. 

See you guys around the forums! 

-Mike 

[Phil_Seamark]

Hi @mshamsiev

Do you combine your datasources in any way or are these three separate tables in Power BI, each with a many to one relationship to the Task Type table?

It sounds like you are on the right track.  Please also double check that all the columns used on both sides of each relationship are the same datatype.

[mshamsiev]

Hi @Phil_Seamark,

Thanks for the reply! All three datasources are separate tables. They all have columns which include 'assignment group' 'task type' and 'date'. So I created three further tables containing each of those variables and matched them. Do I need to combine them?

Much appreciated.

-Mike  

[Phil_Seamark]

Hi @mshamsiev

You don't need to combine them, but if they are as similar as it sounds like, it will make filtering and other measures easier if they are in the same table.  

You can do this in DAX using a UNION function, but I'd recommend you do it in the Query Editor using the Append Queries function on the Home tab.