Forum Discussion
Helper IGlobal Filter for all reports
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
Helper IHow to use Global Filters plz suggest me
Thanks
Helper IHi 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
Srikarnandan7 i have one field country i added that field in all sources but its not joining?
- Srikarnandan7
Can you please create a static table with one column 'Country' and add the countries in that column.
Make sure the 'Country' field has unique values in it and then join.
This is something similar to what I posted in my previous post. Please look at the screenshot in my previous post.
- sushmasushma
As u told i done its joined the table but its not working.
Thanks