cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ONCKdata
Helper I
Helper I

Filter multiple queries withour relationship

Hi,

I am trying to map two different queries of sales team, billed data and sales pipeline data, which have data across multiple ranges months, products and sales persons.

Both queries have no unique identifiers, so there is no way to relate them (they are logically unrelated aswell).

In dashboard, there are graphs of total billed and pipe, I want to apply a filter on product, which is applied to both the graphs. (Please note, there are some products in billed data which are not in pipe)

 

In a long shot, I can create additional table with unique product value and use it as a filter, but I want to apply there are many such filters.

 

I am new to PowerBI, kindly pardon if there are misuse of jargon. Looking forward to your help.

1 ACCEPTED SOLUTION

Hi @ONCKdata,

 

You could create a third table to get the unique column Manufacture, then you can create the relationships with the tables.

 

1. Create the third table in Query Editor by Append Queries as new.

 

append.PNG

 

2. You could remove other columns and the Duplicate rows.

 

Capture.PNG

 

3.Create relationships among the tables like below.

 

relationship.PNG

 

4. Then you could create the Slicer with Manufacture in Append table.

 

report view.PNG

 

For reference,you could have a look at my test pbix file which has been attached below.

 

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.

View solution in original post

4 REPLIES 4
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @ONCKdata

 

You want to create two reports and the reports have no relationship?

 

Besides, the filter only work in one report or mutiple visuals and pages.

 

I 'm not very clear about your requirement. 

 

If it is convenient, could you share a dummy pbix file which can reproduce the scenario and show your expected output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

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.

Hi, thank you for the reply.

Sorry, I might have conufused you with misused terminology. (I have tried to correct the message)

I am attaching the sample file in below link.

sample

 

As you can see, there are currently two different filters for manufacturer. I am looking for a solution to have common filter which can be applied to both graphs.

Hi @ONCKdata,

 

You could create a third table to get the unique column Manufacture, then you can create the relationships with the tables.

 

1. Create the third table in Query Editor by Append Queries as new.

 

append.PNG

 

2. You could remove other columns and the Duplicate rows.

 

Capture.PNG

 

3.Create relationships among the tables like below.

 

relationship.PNG

 

4. Then you could create the Slicer with Manufacture in Append table.

 

report view.PNG

 

For reference,you could have a look at my test pbix file which has been attached below.

 

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.
Anonymous
Not applicable

This helped me fix my report.  Thank you

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.