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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ODJAPO
Frequent Visitor

One report filter for multiple queries

Hello all,

 

I have a report with multiple queries, on all of these queries I have the same 10 first column.

 

When I use a report filter I drag and drop one of the first column of one query but the issue is that this column is not link with the others queries.

 

So how to use a filter for example with the column 2 which will be applied for all the queries ?

 

Thank you in adavance for your help.

1 ACCEPTED SOLUTION

All the heading on all queries do not have to be the same.  When you apend them, the different columns will be picked up as they are.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

8 REPLIES 8
Ashish_Mathur
Super User
Super User

Hi,

 

Create 10 different Tables (one for each of the 10 common columns in all your queries).  Once that is done, create a relationship from the individual queries to the 10 different tables.  In your visuals, drag the common columns from the 1o different tables.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hello all,

 

@Greg_Deckler  I have store an sample in the link below:

test.pbix

 

@Ashish_MathurI am sorry but I am a beginner so I don't understand your answer, I don't know how to create relationship.

 

In the screenshot below I have try to explain my request. The column in red are on all of the queries, so I want to be able to filter my report by on of these column Man Happy

test.png

 

 

 

 

Thanks

Hi,

 

Append data from the 4 queries into a single table first and then build the visuals.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi @Ashish_Mathur,

 

I just send you a sample, actually I have many queries Man Sad

 

On all the queries there are at the begining the same column but then the column header and data are different so I can't append them.

All the heading on all queries do not have to be the same.  When you apend them, the different columns will be picked up as they are.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur,

 

WoW, it's look it is working very well but I don't understand how the append method works.

 

Can you give me an explanation or a support document to get more information ?

 

Than you very much.

 

 

Hi,

 

That is good to hear.  I do not know of any supprt document on this topic.  Please search yourself.  If my reply helped, please mark it as Answer.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Greg_Deckler
Super User
Super User

Can you provide some sample data? This seems like a case where you should either merge all of those tables into a single table or separate out those 10 columns into a separate table.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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