Don't want to summarize on the card

BalaKiran_M · ‎03-24-2023

Experts, My issue looks simple but not able to fix it. I have a amount column kept in the report and set it to Don't summarize, it works fine numbers are matching as expected. And same amount column displayed on the card but it shows summed value, but i don't want to show the summed value, I don't see the don't summarize option when I kept on the card.

Please suggest any work around for the same.

Thank you,

Bala

SamInogic · ‎03-24-2023

Hi @BalaKiran_M ,

Power BI does not have Don't summarize Option when we add a column in Card Visual.

This will be multiple values within single column of the table, but Card Visual is used to show Aggregated Value on the report such as Count, Max, Min, Sum and so on.

So, can you please explain your requirement what you exactly want to display in Card Visual?

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service: http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/

BalaKiran_M · ‎03-24-2023

Thanks @SamInogic for your quick response, The below snasphot will clear you explain the problem.

The Green Marked one is the numbers are populating in the table view when I Don't Summarize the column, next one is Yellow marked one which I don't want. But the same one i displayed on the red marked card, I just want to keep don't summarize like green marked card total number, please help with any possible DAX code or any work around.

SamInogic · ‎03-24-2023

Hi @BalaKiran_M ,

Your table have a column Summed Complaint Amount and have multiple values as shown in Yellow Mark in your screenshot. But when you add the column in Card Visual it is expected output will be single value not the list of values as that of in Table Column.

Card Visual allow only aggregation of values instead of all values as shown in below screenshot,