Forum Discussion

keondopark's avatar
keondopark
Regular Visitor
10 years ago

How can I make string values to appear on pivot table?

Hi, I am now trying to make the date records into table format. But the data column contains both numeric and string values For example, if you have a dataset as below,   Key RowID ColID Data...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

I'm not sure how you are doing that with a Matrix visualization honestly, if you try to use a Text field in the Value for a Matrix, it tends to want to count it versus giving you the text.

  • greggyb's avatar
    greggyb
    Resident Rockstar
    10 years ago

    A measure can return a text datatype. If you can write a measure that evaluates to a single text value appropriately, it should work in a matrix.

    • keondopark's avatar
      keondopark
      Regular Visitor
      10 years ago

      Can you explain in detail??

      • greggyb's avatar
        greggyb
        Resident Rockstar
        10 years ago

        Make a measure, and instead of evaluating arithmetic, evaluate a string:

         

        // DAX
// All below are measures in my model

MyMeasureReturnsText! = 
"This measure returns text"

This Measure returns text based on a field value! = 
CONCATENATEX(
	VALUES( 'Sample'[SomeField] )
	,SWITCH(
		'Sample'[SomeField]
		,1, "That's a one"
		,2, "Well that looks like a 2"
		,3, "By golly, thats a seventeen!"
	)
)

         

        My 'Sample' is just a 3-row table with values of [SomeField] = 1, 2, 3.

        You can see that my matrix uses [SomeField] as the row labels. My measures are both in the Values area. Each returns text.

         

        I'm happy to help more, but I don't know what sort of detail you're looking for.

  • keondopark's avatar
    keondopark
    Regular Visitor
    10 years ago

    Maybe I  made a mistake in writing. 

    I used Matrix for the numeric data, and Table for string data.

    As you said, it automatically counts.