Forum Discussion

Jason2500's avatar
Jason2500
Helper I
5 years ago
Solved

Connecting two tables for line graph

Hi   I am having sales and expense table as below   Date Sales 1.02.2021 15 02.02.2021 43 03.02.2021 45 04.02.2021 56 01.03.2021 43 02.03.2021 21 15.03.2021 12 ...
Need Help
Show and Tell
  • toafk's avatar
    toafk
    5 years ago

    If I get you right.
    Table1 have to columns - Date and Sales

    Table2 ahve to columns - Date and Return

    In the model tab of Power Bi connect the two table by connecting the dates

    Drag the visual on the the report page. Select the Sales and return as values and date as Axis

     

     

     

toafk's avatar
toafk
Frequent Visitor
5 years ago

If I get you right.
Table1 have to columns - Date and Sales

Table2 ahve to columns - Date and Return

In the model tab of Power Bi connect the two table by connecting the dates

Drag the visual on the the report page. Select the Sales and return as values and date as Axis