cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ODJAPO Frequent Visitor
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

Accepted Solutions
Super User
Super User

Re: One report filter for multiple queries

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.

8 REPLIES 8
Super User
Super User

Re: One report filter for multiple queries

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Super User

Re: One report filter for multiple queries

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.

ODJAPO Frequent Visitor
Frequent Visitor

Re: One report filter for multiple queries

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

Super User
Super User

Re: One report filter for multiple queries

Hi,

 

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

ODJAPO Frequent Visitor
Frequent Visitor

Re: One report filter for multiple queries

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.

Super User
Super User

Re: One report filter for multiple queries

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.

ODJAPO Frequent Visitor
Frequent Visitor

Re: One report filter for multiple queries

@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.

 

 

Super User
Super User

Re: One report filter for multiple queries

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.