Forum Discussion

swebb's avatar
swebb
Helper II
3 years ago
Solved

Different values between card visual and table visual

I'm having an issue where I am using the same conditional column, which does some math based on values in other columns, and gives an output dollar amount. I have two visauls on one page of my report...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi swebb ,

     

    For the table visual, because of the existence of other fields, it will be affected by the row context, and the data will be different.

    For a card visual, it can only have one field, and if it's a column, it will let you choose an aggregation action, such as sum below.

    If there's only the Value column in the table visual, and then you also select the aggregate operation for sum, then the result of the table visual is the same as the card visual at this time.

     

     

    Table visual in Power BI - Power BI | Microsoft Learn

    Card visualizations (large number tiles) - Power BI | Microsoft Learn

     

    If you still have doubts, it's better to provide some dummy data, along with the expected outcome.

     

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

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