Forum Discussion

pborah's avatar
pborah
Icon for Solution Sage rankSolution Sage
1 year ago

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

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.

General Comment
Show and Tell

5 Replies

    • pborah's avatar
      pborah
      Icon for Solution Sage rankSolution Sage
      1 year ago

      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's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        1 year ago

        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.

  • v-sdhruv's avatar
    v-sdhruv
    Icon for Community Support rankCommunity Support
    1 year ago

    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!

  • v-sdhruv's avatar
    v-sdhruv
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi pborah ,
    I hope you were able to raise the concern in the ideas forum. We would be closing this ticket.
    If you still face any issue, feel free to reach out to the community and we would he glad to assist you.
    Thank you for reaching out on Microsoft Community forum.