Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I have a table of products :
Product_Name
A
B
C
and a table of product definition where I am going to identify properties of each product:
Product_ID | Property
A Color
A Shape
A Stiffness
B Color
C Shape
C Stiffness
What I would like to have is a checklist of all distint properties and when I select in slicer a specific product, I can see in this table if property is defined or not (true or false): let's say prodct C is currenlty selected:
Distinct_properties | measure_propety_defined
Color False
Shape True
Stiffness True
I tried with CONTAINS but can only work within same table and tried also DISTINCT but did not figure a way to do what I need.
Many thanks in advance for any support
Solved! Go to Solution.
Consider this solution and remember we are BI community voluntrees so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works. Thank you !
Click here to see a demo solution
In edit query right click on the 2nd table and select Reference.
Call the new table Properties
Edit the Properties table
Right click on the property column and remove other columns
Right click on the property column and remove duplicates
In relationships, delete all relationships
The create Product 1:M Fact relationships
The create Property 1:M Fact relationships
Create measure
Defined = IF( ISEMPTY(Facts), "False", "True" )
Add a matrix visual with
Row = Products[Product Id]
Column = Properties[Row = Products[Product Id]
Values = Defined
Click here to see a demo solution
Consider this solution and remember we are BI community voluntrees so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works. Thank you !
Click here to see a demo solution
In edit query right click on the 2nd table and select Reference.
Call the new table Properties
Edit the Properties table
Right click on the property column and remove other columns
Right click on the property column and remove duplicates
In relationships, delete all relationships
The create Product 1:M Fact relationships
The create Property 1:M Fact relationships
Create measure
Defined = IF( ISEMPTY(Facts), "False", "True" )
Add a matrix visual with
Row = Products[Product Id]
Column = Properties[Row = Products[Product Id]
Values = Defined
Click here to see a demo solution
@speedramps The matrix visual is indeed a smart solution ! Many thanks for your kind support.
User | Count |
---|---|
134 | |
72 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |