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 in...
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.
For starters in Power Query; spilt column by delimiter (comma) and use these row values next.