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.

[v-sdhruv]

Hi @pborah ,

I can understand the frustration.
Those aggregation options are generally available in tables or matrix visuals, or in measures, but not directly exposed in the Card visual UI unless you explicitly define the behavior beforehand.
Power BI seems to assume a Card is for high-level metrics (totals, counts, KPIs), not textual or Boolean values.

You can raise your idea on ideas forum. If it gets  enough votes, this might get implemented.

Hope this helps!

[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.