Forum Discussion
Helper IGlobal Filter for all reports
Hi Team,
I have 3 different sources (Source 1, Source 2 and Source 3). I have created multiple visuals in one page using these 3 sources.
When I create a drop down filter from Source 3, it filters the visuals which were build from Source 3. My requirement is when I select a value in Drop down all the visuals should get filtered irrespective of the source. Is it possible in Power BI.
Thanks,
Srikar
Srikarnandan7 you need to have a table with the column you trying to join on, that has unique values, so if you have multiple values of that column in both tables, you need to build a new table with only the unique values of the decription, build and build a relationship from both those tables to that table
alternatively if both those tables are the same structure and content you can just append one on top of the other in power query or do a union in dax. depends on the data which is hard to tell with the info you given
11 Replies
- vanessafvg
Community Champion
Srikarnandan7 can you show me what your data looks like?
effectively you need a bridge table that links the 3 source together
ie
screen shot of the relationship view
examples of what you want to filter by
Srikarnandan7Hi vanessafvg
Sorry for the delayed response..
I tried to join the tables to have global filter, but shows me the message 'You cannot create the relationship between these columns becasue one of the columns must have unique values.'
I would like to take a moment to explain the type of data I have.
I do have 2 tables. Lets say Table 1 from Source1 and Table 2 from Source 2
Table1 has a description column with data like 'XXXX-UK-XXXX', Table2 also has the description column 'XXXX-UK-XXXXX'.
Now I extract the Region from above 2 description fields which will be UK, US.
Now I wanted to apply the filter 'Region' to all of the visuals, but it shows me the above message when I tried to join.
Please suggest
- vanessafvg
Srikarnandan7 you need to have a table with the column you trying to join on, that has unique values, so if you have multiple values of that column in both tables, you need to build a new table with only the unique values of the decription, build and build a relationship from both those tables to that table
alternatively if both those tables are the same structure and content you can just append one on top of the other in power query or do a union in dax. depends on the data which is hard to tell with the info you given
sushmasushmaHow to use Global Filters plz suggest me
Thanks
- Srikarnandan7
Hi Sushma,
I'm suggesting this as per my above experience:
If you are using multiple different sources then
1. You need to have the same field (Ex: Country) exist in all the sources and make a join on the filed Country. Drag the field Country in filter section so that it will filter all the visuals on the page as there is a join defined on this field across multiple sources.
OR
2. If you do not have same field exist in all the sources then create a table in Power BI (Modelling Menu-->Enter Data)with required values in a column as shown below and then make a join between newly created table and existing tables in different sources
- sushmasushma
Thank you so much
- sushmasushma
Hiiii
I have 1 source and i have created 3 visuals means 3 page in power BI for only one source.In first page i have so many filters if i work any one filter its working in first page itself but its not working in remaining pages.plz suggest me
Thanks in advance