Forum Discussion
Solved
Matrix conditional formatting
Hello! I am attempting to create a matrix that displays a dot based on values that are in a comma delimited column (Fig. 1). How may I display these distinct values across the top of a matrix and indicate each meal that may contain that item (Fig. 2)?
Fig. 1
Fig. 2
Thank you!
Ok, you can keep that table unrelated, and in DAX use INTERSECT to check for the presence and then count, when > 0 then you column needs to be populated.
4 Replies
For starters in Power Query; spilt column by delimiter (comma) and use these row values next.
Ok, you can keep that table unrelated, and in DAX use INTERSECT to check for the presence and then count, when > 0 then you column needs to be populated.
