Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
https://drive.google.com/file/d/0B_7ViRmIIPNgY1F2cUdkRGcxU28/view?usp=sharing
See this pbix ^^
I have connected the tables but when I select the filter value (f.e. supplier or filter), the invoiceamount doesn't reflect the changes.
Is it because catalog table has many duplicate rows:
Variant 1 to n Catalog n to 1 Filter
and catalog n to 1 supplier
Solved! Go to Solution.
Depends of the info that you want to display you need to modify your relations. Only in tables that you need the propagation change to both.
About Apply security filter in both directions is not necessary. This is generally use in direct Queries.
Regards
Victor
Try changing the Cross Filter Direction to Both (In Variant with Catalog Table)
Regards
Victor
Lima - Peru
Thanks that worked. Do I need to set "Apply security filter in both directions"?
Am I good to go anyway the way I have set my relations?
Your relations look Ok. Only need to see the flow of the filters in your table.
For example:
In your original file, the relation don't be propagate between the tables because the relation between invert and catalog are single. So when you filter using Suppler the flow stop in Catalog. (Many to One Single Direction)
Regards
Victor
Lima - Peru
Thanks. Do you mean I have to set relations to "Both" for the other tables as well? Supplier, Category and Filtervalue?
What about "Apply security filter in both directions"?
Depends of the info that you want to display you need to modify your relations. Only in tables that you need the propagation change to both.
About Apply security filter in both directions is not necessary. This is generally use in direct Queries.
Regards
Victor
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
104 | |
76 | |
70 | |
51 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |