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.
Hi,
I need to create two filters containing "Company" and "Type". The filter needs to reflect on my graph as show below:
When I try to filter by "Type" one of those two values remains the same.
I've tried to create a relation between the two aswell, but no success...
All the details are in this PBIX File.
Any ideas on how to handle this problem?
Thanks in advance!
Solved! Go to Solution.
Hi,
you are trying to filter two different fact tables by using fields within one of them, this is usually not a good idea.
Create dimensions/tables for each of the columns the two tables have in common, connect these two new tables to both of the fact tables, and change the slicers to use type and company from these two new tables
pbix
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Hi,
you are trying to filter two different fact tables by using fields within one of them, this is usually not a good idea.
Create dimensions/tables for each of the columns the two tables have in common, connect these two new tables to both of the fact tables, and change the slicers to use type and company from these two new tables
pbix
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |