Is it possible to use text in Values?

[edcnn]

I have a several tables. I need to make that slicers horizontal contains the date, slicers vertical - the person. When I select a date and person, I get a value - text that contains comment which person left on this day. But I can not insert text into Values.
How to implement my task?

 

[Laurent C]

You cannot add a text column to the pivot values, but you can define a measure that returns a text:
=IF(HASONEVALUE(YourTable[YourColumn]),VALUES(YourTable[YourColumn]);"Many values")

Note that your measure has to return a single value.

 

[edcnn]

You cannot add a text column to the pivot values, but you can define a measure that returns a text:
=IF(HASONEVALUE(YourTable[YourColumn]),VALUES(YourTable[YourColumn]);"Many values")

Note that your measure has to return a single value.

Many thanks. But how I can implement my simple task?
In fact, the problem is even easier
I need to place a calendar on the Excel sheet and a simple table (person - comment)

 

[Laurent C]

It seems to me you have just answered your own question. Am I right?

 

[Laurent C]

Also, if you just need to display the columns Person & Comment, then you do not need to create a measure for that. Just drag & drop both fields on row, and filter on the date.

 

[MD610]

Depending how your data tables are set up and related, the option of adding both Person and Comment to the rows will probably be easiest.

Often when you do it like this (again this depends on what your tables are and how they are related) you will need to add some type of measure to the values field to get your pivot to filter properly when you use the slicers. The measure can be something simple like just a count of the comments. It will probably show up as 1 for every row in your pivot but that doesn't matter. You need the measure to "unify" everything going on in your table relationships, pivots, and slicers. If you don't want the measure column to show in your final report just hide the column in excel.