One Line Chart, 2 Tables

e175429 — Mon, 12 Aug 2024 16:10:50 GMT

Ok, idk HOW I'm doing this wrong.

Hey All,

I have 2 tables, one form 2023, one from 2024.

Both tables are joined on a 1:1 relationship.

Seperately, their lines charts look like so:

2023

2024

When I try to graph their lines on the same chart, I get this:

It only shows 2023. Neither column is summarized.

IDK if it matters (i don't think it should) but the ID totals on each graph is different. for 2023, ID total 249. 2024 ID total is 393

Re: One Line Chart, 2 Tables

quantumudit — Mon, 12 Aug 2024 17:14:16 GMT

Hello e175429

The problem likely stems from inadequate data modelling. To better comprehend your needs, please provide a sample dataset along with any supplementary details, such as the relationships between tables, ID columns, etc.

Additionally, the 1-to-1 relationship depicted in the screenshot you provided appears to be unnecessary.

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree

topic One Line Chart, 2 Tables in DAX Commands and Tips

One Line Chart, 2 Tables

Re: One Line Chart, 2 Tables