PUTTING VALUES FROM DIFFERENT TABLES IN THE SAME GRAPH

[Anonymous]

Hi experts!

I'm trying to create a graph that has two measurements from different tables. They are both unit values and have similar numbers, but when I put them together in a graph, it doesnt show the values by month, as below:

first graph are the values together. 2nd and 3rd are them separetly, showing data perfetly.

and that's how I have sorted data in the first graph:
the "month" axis comes from one of the tables

Could you help me set up both tables so I can have the data sorted in a single graph?

I have already linked both month columns from each table.

thanks for the help 😉

[v-easonf-msft]

Hi, @Anonymous 

Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi,  @Anonymous 

It's so strange that you still encounter this problem after you have established  a relationship between tables.

Can you share me  the screenshots about your table relationship  in model view?

Please recheck whether you have missed something wrong  in the measure [sell out (MSU)] first.

PS：I made a sample file.You can check whether it helps.

Best Regards,
Community Support Team _ Eason

[Greg_Deckler · Accepted solution]

@Anonymous - Seems like you do not have a relationship between your two tables? Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[nandic]

@Anonymous , it is good practice to have Date table (marked as Date table in order to use time intelligence functions).
Once you have this table, create join to both of these existing tables and use Date table to display date fields on the report.
This way there will be no multiplications.