Data Type True/False not displaying in Matrix table

[briangreen]

Data with a data type of "True/False" displays as an INT - "Count of " rather than True or False when used in a Matrix Table

[v-yuezhe-msft]

@briangreen ,

When you drag the "True/False" column to values section of Matrix, it will be counted by default. If you want to show True/False for this column, please create a table visual and choose "Don't summarize" for this column.


Regards,
Lydia

[Anonymous]

@v-yuezhe-msft This is possible if you use table (like you do in the screenshot) but not with the matrix. If you use matrix, the "Don't Summarize" option disappear:

[Marco57]

@v-yuezhe-msft 

How is this marked as Delivered while the answer is not related to the question? Question is on matrix and answer is on tables? I am dealing with same issue and can't find a mean to resolve it.

For strings, matrix offers a mean to aggregate over first or last data. For numbers we can choose min or max or mean ... but what is happening for True/False (booleans) ? Why are we only havnig the count aggregation shown? This makes absolutely no sense as we want to display some data there about that boolean.

I am obliged to use a matrix visualization because of other requirements that can only be satisfied with matrix viz

Thank you

[SamuelAB]

@v-yuezhe-msft We know it can be done in a Table, we are asking how to do it specifically in a matrix. The answer is not useful and sidesteps the question:

What is the best practice to display True/False type data in a matrix? (not a Table)