topic Re: Visualizations Not Showing Same Data in Custom Visuals Development Discussion

Visualizations Not Showing Same Data

nhimt — Wed, 12 Jun 2024 21:01:45 GMT

Hello!

I have two visualizations, I am wanting to show the same data on both but there seems to be a discrepancy and I can't figure out why.

The goal is to show totals for a field (Resolved) by month. In the first visual below, I have a table view and created cards for the totals each month, these totals match what the source is showing. The applied filters for the table are current year (2024) and full months complete so far, (Jan-May).

When I add the same field (Resolved) to the below chart, the numbers change however. Once again, the filters applied are the current year (2024) and full months complete (Jan-May).

The numbers are mostly close, but not the same.

Month	Chart	Table (correct)	difference
January	95	92	3
February	76	75	1
March	70	79	-9
April	72	77	-5
May	74	83	-9

Any ideas would be welcomed! Thanks

Re: Visualizations Not Showing Same Data

lbendlin — Thu, 13 Jun 2024 22:24:33 GMT

You will want to use a multi card visual instead of individual cards.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Visualizations Not Showing Same Data

nhimt — Thu, 11 Jul 2024 12:39:20 GMT

Hi!

Thanks for replying, I am not sure how to approach the multi card visual for a column chart, please explain further if possible.

After further investigation I was able to fix the data discrepancy, but had to create two separate charts. I need the second chart (Resolution Data) to be merged with the Main Chart page but I can't get it to work correctly - it either doesnt show or the numbers are wrong. The data on both pages is correct currently.

Re: Visualizations Not Showing Same Data

lbendlin — Thu, 11 Jul 2024 10:42:23 GMT

See attached. I chose to show the resolved ones as negatives.

note the active and inactive relationship.

Re: Visualizations Not Showing Same Data

nhimt — Fri, 28 Jun 2024 21:00:46 GMT

I have been trying to copy the steps over to my real workbook and am having troubles. The active line is correct but the bars are not. I have reviewed all of the fields between the two files and can't see any differences. Did you manipulate the data somehow?

Re: Visualizations Not Showing Same Data

lbendlin — Sat, 29 Jun 2024 01:27:06 GMT

make sure you wire the data model correctly. The created and resolved columns must be date, not datetime.

Re: Visualizations Not Showing Same Data

nhimt — Wed, 03 Jul 2024 19:09:26 GMT

Hi Ibendlin,

I did check the columns and they are "date" type, matching your returned file. I did have the autodate table set as an date heirachy instead of a date table, which I changed without any change to the visual as previously posted.

I have compared columns and measures without finding any difference. Do you have any other ideas?

Thanks

Re: Visualizations Not Showing Same Data

lbendlin — Thu, 04 Jul 2024 17:48:50 GMT

Post a sample version of your file.

Re: Visualizations Not Showing Same Data

nhimt — Thu, 11 Jul 2024 03:24:59 GMT

Please see the following link, please use the same link to re-upload the file as well. Thanks

Re: Visualizations Not Showing Same Data

lbendlin — Thu, 11 Jul 2024 10:42:00 GMT

Looks ok to me?

What do you want changed?

Re: Visualizations Not Showing Same Data

nhimt — Wed, 10 Jul 2024 21:21:39 GMT

It should match the screenshot you posted previously, the line is incorrect and and resolved data isn't on the chart.

Re: Visualizations Not Showing Same Data

lbendlin — Wed, 10 Jul 2024 21:23:11 GMT

I reposted my reply

Re: Visualizations Not Showing Same Data

nhimt — Thu, 11 Jul 2024 03:26:04 GMT

Thank you! Are you able to remove the file download from your replies?

Re: Visualizations Not Showing Same Data

lbendlin — Thu, 11 Jul 2024 10:45:13 GMT

Hmm. I was able to remove it from my replies but not from the marked answer. Might need to ask a forum moderator for help, or unmark as answer.

Re: Visualizations Not Showing Same Data

nhimt — Thu, 11 Jul 2024 12:40:59 GMT

From my view all of the links are gone, so all good. Thanks so much!