Why is the New Card visual limiting aggregation options for a True/False boolean column?

[pborah]

I'm trying to display a bunch of fields in the new Card visual. I have one column that contains Boolean data. I have verified it is not 0 or 1 but actual "True"/"False" even in the ETL (transformation) stage. The card visual automatically summarizes this to count and the only other aggregation option is distinct count. No other options such as  - first, last, earliest, or latest (?) are available. This is frustratingly baffling to me from a design perspective. Who thought this would be a smart idea?

Yes I am aware I can get around it by creating a measure or a different calculated column but it should not be this tricky to implement such a simple thing. I hope a dev or an engineer sees this.

[Greg_Deckler]

@pborah I can only offer you my support and a virtual shoulder to cry on.

[pborah]

@Greg_Deckler I'll take it. As I implement a workaround that literally copies the True/False values to a calculated column with a conditional statement (and it works!), I can't figure out whether to laugh or cry at the engineers. 

I swear this product has gone downhill and backwards and forwards and then backwards again a few times since Microsoft Fabric had a new VP in early 2024. All my woes began with the January 2024 update.

[Greg_Deckler]

@pborah Totally with you, I have made numerous videos on my channel complaining about just how downhill Power BI has gone since Fabric was announced. It just continues to get worse.