How to return string values in the Matrix visual values, I tried using coalesce function but it shows only the counts or distinct counts. I cannot modify the source data that is dataset. I need to convert this table: Issue ID Attribute value 1 Priority high 1 cat a 1 xxx …

Hello @rama_kumar , welcome to the Quick Sight community! My first thought is to try making new calculated fields to manage the pivot. You could try the following: Priority = ifelse({attribute} = 'Priority", {value}, NULL) Do the same for cat and xxx, and you should be able to leave issue id. The…

Hi @WLS-D , Thanks for your response. I tried the calculated field as suggested. It gives additional null values and not pivoting as expected. Please refer the screenshot. [Calc Field]

Hey @rama_kumar If you have empty strings or null values in rows of your dataset then it will return them. To exclude rows with null values or empty strings you could create filters on your visual from your calculated fields where the conditions is set to “does not equal” and leave the value blank…

Hi @WLS-D , Thanks, no luck! This works only if there is one calculated filed the dashboards we are working on have multiple calculated fields. Is it a native function in quicksight that does not allow returning or aggregating text values in the matrix visual as values?? It converts to first valu…

Hello @rama_kumar In Quick Sight, tables and pivot tables default to aggregating text values as count or count distinct. I can mark this as a feature request for the Quick Sight team.

Returning text values in matrix visual values

Q&A

rama_kumar June 3, 2025, 6:16am 4

Is it possible to fix this with firstValue function?

Text to Number format conversion

Topic		Replies	Views
How to show the text into valuves in the table Q&A quick-sight , calculations , pivot-table , Business-Intelligence-Engineer	1	155	May 29, 2024
How to Display text field (no calcualtion) to a pivot table as value? Q&A charts , analysis , feature-request , quick-sight	19	20792	June 1, 2026
Unable to visualize string data in pivot table Q&A admin , error , feature-request , quick-sight	12	349	August 27, 2024
Adding text fileds as values in a pivot table Q&A feature-request , quick-sight , visuals , calculations , pivot-table , Business-Intelligence-Engineer	4	115	February 6, 2025
Text in a pivot table Q&A formatting , quick-sight , calculations , Business-Intelligence-Engineer	7	557	January 23, 2024

Returning text values in matrix visual values

Related topics