Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BalaKiran_M
Frequent Visitor

Don't want to summarize on the card

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

3 REPLIES 3
SamInogic
Super User
Super User

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/

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.

 

BalaKiran_M_0-1679656699499.png

 

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,

SamInogic_0-1679659366316.png


If we don't want to aggregate the data from column then instead of Card Visual we should prefer to use matrix or Table on Power BI Report.


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/



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors