Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
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.
Hello all,
@Greg_Deckler I have store an sample in the link below:
@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
Thanks
Hi,
Append data from the 4 queries into a single table first and then build the visuals.
Hi @Ashish_Mathur,
I just send you a sample, actually I have many queries
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.
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.
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |