Convert values of matrix from number to text

[Anonymous]

Hi Team,

I have created an matrix and in the matrix, I have column called Traffic Spikes. That column have values of 0 or 1. I put that column in the values field on matrix. Then I'm doing Max of Traffic Spikes. Is there way to turn 0 or 1 to Yes or No without impacting the Max of Traffic Spikes? I would like to keep the maximum 

Thanks

[parry2k]

@Anonymous you can create a measure to get yes and no value

Yes and No Measure = 
IF ( MAX ( Table[Traffic Spikes] ) = 0, "No", "Yes" )

[Anonymous]

@parry2k I tried that. But messes up my Matrix.

[parry2k · Accepted solution]

@Anonymous try this

Yes or No Measure = 
IF ( MAX ( Table[Traffic Spikes] ) = 0, "No" ,
IF ( MAX ( Table[Traffic Spikes] ) = 1, "Yes" )
)

[Anonymous]

@parry2k I think i found the issue. I have an filter which looks at critical sites for traffic. When I use that filter when measure is selected in value column, Filter doe not work with measure. It works without messure.  Do i need to add something to measure so Filter will work?

[parry2k]

@Anonymous so surely I don't see the whole picture, if you are ok, share pbix file wiht sample data and remove any sensitive information before sharing.

[Anonymous]

@parry2k I can try. I have powerbi with million rows of data. Tough to share the file. I have column in data called CriticalSiteYn. CriticalSiteColumn is in different table. Value of that column is = Critical or null. Do I need to create an another measure so that criticalsite will work on that measure we just created. If i remove the filter, measures works fine on all data but doesn't filter when selecting critical.