Forum Discussion
Visualizations Not Showing Same Data
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
See attached. I chose to show the resolved ones as negatives.
note the active and inactive relationship.
Looks ok to me?
What do you want changed?
14 Replies
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/1447523Hi!
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.See attached. I chose to show the resolved ones as negatives.
note the active and inactive relationship.
