Can't use First or Last in Value Visualization; Only Count or Count (Distinct)

[Anonymous]

I have a column that is of Data Type True/False.

The Default Summarization is currently configured as:

I'm trying to use this in a Value visualization. However, when I do so, the only options for summarizing the value are Count (Distinct) and Count:

This visualization has the following filters currently:

Where Instructor Name and Course Name are columns in the same table as the column in my visualization. Date is a column from the Date table which has a 1 to many relationship with a date column in the data table.

I want to use the First or Last options for this visualization and don't understand why they are not available to me. Can anyone explain why Count and Count (Distinct) are the only options?

[v-xiaotang]

Hi @Anonymous 

These are usually reserved for text values. First will provide you with the first value of the alpha sort, and last will provide you with the last value of the alpha sort.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM]

Hi @Anonymous 

Change the column type to text.

Or use Convert Dax to add a new column to your table like this:

New Column = CONVERT('Table'[T-F],STRING)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos✌️!!

[Anonymous]

Hi @VahidDM ,

Thank you for the response. Can you explain why it is necessary to use string instead of True/False? Ultimately, the column should be a True/False or binary column, not a string/text.

-Caleb

[VahidDM · Accepted solution]

Hi @Anonymous 

You can keep your column in True/False format and add a new column with converted values to String and use that in your visual.

The aggregation option for True/False in that visual is just Count and Count (Distinct).

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos🙏!!