Text Values in Matrix Visual

[Anonymous]

Hi all,

I am using a Matrix visual and I am adding in text strings into the Values using SELECTEDVALUE. for example for the rows I placed the Account Name and for the values I have the Child Name (ChildName = SELECTEDVALUE(Table[ChildName]) & a bunch of other numerical values. The problem I face is the Child Account is showing blank, however when I filter to a specific Account Name using a slicer, the Child Name will populate. Is there anyway to fix this/ get around this issue & show all the Child Account Names in the Matrix Values section? 

Thank you!

[amitchandak · Accepted solution]

@Anonymous , Try like

ChildName = Max(Table[ChildName])

if not,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.