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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Ruehlen23
Frequent Visitor

Count in Card and Graph visual do not match corresponding Table visual

Hello,

I have the same data displayed in a Table, Chart, and Card. The count in the Chart and Card are higher than the corresponding data in the table for some dates. See example highlighted in pic for 10/4 the Chart and Card count 2 but the table only has 1 entry. Any suggestions are appreciated.

not rejected visual_count off.png

Thank you.

2 REPLIES 2
PhilipTreacy
Super User
Super User

Hi @Ruehlen23 

 

Isn't the card showing 25?

 

Very dificult to help you without access to your data/file.

 

My instinct says you are showing different data/values in the card, table and chart.

 

Can you supply your file please?

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Hello Phil,

Thanks for taking a look. Unfortunately I can't share the file due to agency policy. The table only has 20 data points, and when I take the table visualization and convert it to the chart visualization I get the same result as shown in the picture where the chart and card visualization indicate 25 data points total instead of 20. When I compare them, for example on 10/4, the chart has a count of 2 data points whereas the table has a count of 1. Below is the data table. I appreciate any assistance, newbie here. 

Regards,

Nevada

field valuefield valueCalculated columnfield valuefield value, null value replaced with "not rejected"field valuefield valuefield valuefield value
ID#Temp.Spec. AgeTestStatusSpecimenWarningCodeFinalCollectedDate ReceivedABC
97Cold6OOSnot rejectedy10/21/202210/27/2022B
99Cold6Donenot rejectedx10/21/202210/27/2022SP
11Cold10OOSnot rejectedy10/14/202210/24/2022V
90Cold18Donenot rejectedx9/24/202210/12/2022Y
70Ambient2Donenot rejectedx10/4/202210/6/2022C
53Cold6OOSnot rejectedy9/28/202210/4/2022ST
34Cold6Donenot rejectedx9/16/20229/22/2022T
35Cold6OOSnot rejectedy9/16/20229/22/2022T
39Cold-65741Donenot rejectedx9/20/22029/22/2022TP
38Cold-65741Donenot rejectedx9/20/22029/22/2022TP
37Cold-65741Donenot rejectedx9/20/22029/22/2022TP
48Cold6Donenot rejectedx9/9/20229/15/2022L
46Cold6Donenot rejectedx9/9/20229/15/2022L
47Cold6OOSnot rejectedy9/9/20229/15/2022L
19Ambient4Donenot rejectedx9/8/20229/12/2022C
17Ambient4Donenot rejectedx9/8/20229/12/2022C
16Ambient4Donenot rejectedx9/8/20229/12/2022C
18Ambient4OOSnot rejectedy9/8/20229/12/2022C
44Cold6Donenot rejectedx9/6/20229/12/2022T
43Cold6Donenot rejectedx9/6/20229/12/2022T

not rejected visual_count off_2.PNG 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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