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
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
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.