Displaying text in a matrix with a switch measure

[hlg551]

Hello,

I am trying to use a matrix to display information, both numerical and text. I have slicers to choose specific dates.

I am using a switch measure for which I created headers in excel. Those headers are my columns and my rows is location. 

Is there a function that simply show every value if the data is text?

Any help would be greatly appriciated 🙂

[v-xiaotang]

Hi @hlg551 

May you kindly provide your sample data and expected result?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

Can you please post some sample data and a depiction of the expected result?