cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rajatahuja Frequent Visitor
Frequent Visitor

Combining 3 Graph with different data in X axis and Y axis

I have the excel data in following format(attached).There are 3 graphs ,I want to combine them into 1 graph. I have tried using scatter Chart but power BI doesn't allow to add 3-X axis and 3-Y axis.How can I represent this data-what chart type would allow to represent this data OR what can do I do to reoslve this problem..

 

Capture11.PNG  

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Combining 3 Graph with different data in X axis and Y axis

HI @rajatahuja ,

 

Based on the information you share you should create a calendar table (DAX link or M Language link) then create a relationship between that table and the other 3 tables. Use the date calendar column to create your common axis and place the values from the other tables.

 

3Tables.png3tables_relation.png

 

Check PBIX file attach.

 

Regards,

MFelix

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




2 REPLIES 2
Super User
Super User

Re: Combining 3 Graph with different data in X axis and Y axis

HI @rajatahuja ,

 

Based on the information you share you should create a calendar table (DAX link or M Language link) then create a relationship between that table and the other 3 tables. Use the date calendar column to create your common axis and place the values from the other tables.

 

3Tables.png3tables_relation.png

 

Check PBIX file attach.

 

Regards,

MFelix

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Highlighted
Super User
Super User

Re: Combining 3 Graph with different data in X axis and Y axis

HI @rajatahuja ,

 

Based on the information you share you should create a calendar table (DAX link or M Language link) then create a relationship between that table and the other 3 tables. Use the date calendar column to create your common axis and place the values from the other tables.

 

3Tables.png3tables_relation.png

 

Check PBIX file attach.

 

Regards,

MFelix

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!