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.

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.

One report filter for multiple queries | Microsoft Fabric Community

Greg_Deckler
Community Champion
8 years ago
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.
Ashish_Mathur
Super User
8 years ago
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
  8 years ago
  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 :manhappy:
  
  Thanks
  - Ashish_Mathur
    Super User
    8 years ago
    Hi,
    
    Append data from the 4 queries into a single table first and then build the visuals.