Forum Discussion

lardo5150's avatar
lardo5150
Microsoft Employee
4 years ago
Solved

Matrix with Slicer for Values (string values)

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?