Forum Discussion
Solved
Help formatting a Matrix visual/Is what I want to do possible?
Good day, I am attempting to build a matrix to show data imported from snowflake. The relationships between the data are as follows: Person ----1..*------->Policy Policy ----...
Hi KCarlton96 ,
Please try:
Status' = IF(ISINSCOPE('Table'[Requirement]),MAX('Table'[Status])) Date' = IF(ISINSCOPE('Table'[Requirement]),MAX('Table'[Date]))Then apply it to the matrix visual:
Turn on "Show items with no data":
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jianboli-msft
Community Support
Community SupportHi KCarlton96 ,
Please try:
Status' = IF(ISINSCOPE('Table'[Requirement]),MAX('Table'[Status]))
Date' = IF(ISINSCOPE('Table'[Requirement]),MAX('Table'[Date]))Then apply it to the matrix visual:
Turn on "Show items with no data":
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much!
