Matrix with Slicer for Values (string values)

[lardo5150]

I  have a dataverse talble that holds the following information for EACH engineer:

Name, Date, TotalAssigned, TotalCrits, TotalB, etc.

The values in the dataverse, are strings/text, even though they are numbers.

I want to create a matrix with a slicer.

I found some documentation on this, but they all call for measures, and I cant do a measure on the strings.

Could someone walk me through this?

So in the dataverse, I am pulling the following table:

I want to be able to list each engineer for rows, the columns be the dates, and the values be one of the choices in the slicer.

I created a new table with the case types:

Here is what I am trying to accomplish:

When they click on the item in the slicer, under the date column for each engineer will populate the value.

How can I accomplish this without measures?  Or can you create a measure on a text/string?

[lardo5150 · Accepted solution]

I resolved this using htis video:

https://www.youtube.com/watch?v=_sxLEGRCo28&t=342s

and using selectedvalue