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

Filter multiple queries using same column

Hello, I suppose this is a basic question, but I haven't been able to search for it properly I have many tables with a common column ("Brand"). I'd like to filter the report by brand, without having to filter every table one by one. How can I tell the model that the "Brand" column is shared by every table, and thus should filter everything when I select a brand to show? I hope my question is clear. Thanks!
1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

Hi, @jatpola 

According to your description, I think you can try to create a ‘Slicer’ table that can be used to place into the slicer. Then you can go to the relationship view to link each table which contains the [Brand] column to the ‘Slicer’ table, then the Slicer can filter data in each table, like this:

v-robertq-msft_0-1615281626323.png

v-robertq-msft_1-1615281626325.png

v-robertq-msft_2-1615281626355.png

 

And you can get what you want.

You can download my test pbix file here

 

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

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

2 REPLIES 2
v-robertq-msft
Community Support
Community Support

Hi, @jatpola 

According to your description, I think you can try to create a ‘Slicer’ table that can be used to place into the slicer. Then you can go to the relationship view to link each table which contains the [Brand] column to the ‘Slicer’ table, then the Slicer can filter data in each table, like this:

v-robertq-msft_0-1615281626323.png

v-robertq-msft_1-1615281626325.png

v-robertq-msft_2-1615281626355.png

 

And you can get what you want.

You can download my test pbix file here

 

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

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

PC2790
Impactful Individual
Impactful Individual

Hello @jatpola ,

 

If you have proper relationship among the tables base don the common column(in your case it is 'Brand'), it will automatically apply the filter on your visuals unless and until you are explicitly ignoring any filter using measures.

More about relationship - here

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

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.