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 guys,
I have a long table of Products having various attributes - size, color, etc. I would like to have a matrix to "benchmark" (compare) particular product's attributes against according attributes of another small subset of products.
So, I duplicated my Products table to Products Benchmarks and then created a 'Union Table':
Solved! Go to Solution.
Hi @Anonymous ,
Please check:
1. Create a measure.
Measure =
IF (
MAX ( 'Union Table'[Product Name] ) = SELECTEDVALUE ( Products[Product Name] )
|| MAX ( 'Union Table'[Product Name] )
IN VALUES ( 'Products Benchmarks'[Product Name] ),
1
)
2. Put it on "Filters on this visual" of your table visual.
3. Test.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
The cause is that there is no relationship among your tables.
Please Create and manage relationships in Power BI Desktop.
In addition, it is suggested to understand the Unpivot related content.
Then, you can create a matrix visual like so:
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Icey,
I'm not sure how relationship can solve my issue.
I assume, you meant 'Products' to 'Union Table' and 'Products Benchmarks' to 'Union Table' relationship in this case (both by Product Name field). If I do it this way, then the final visual (matrix for 'Union Table') shows the intersection of what's selected by 2 slicers (i.e. products selected in both slicers simultaneously), whereas I need the union of what's selected by 2 slicers (i.e. products selected in at least one of 2 slicers).
Hi @Anonymous ,
Please check:
1. Create a measure.
Measure =
IF (
MAX ( 'Union Table'[Product Name] ) = SELECTEDVALUE ( Products[Product Name] )
|| MAX ( 'Union Table'[Product Name] )
IN VALUES ( 'Products Benchmarks'[Product Name] ),
1
)
2. Put it on "Filters on this visual" of your table visual.
3. Test.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |