Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Make line graphics

Hello! I am new to power BI, I need to show the following data in a line chart.

In one table I have product, price October and month (November) and in another table I have price September and month (September). Both are related by the product field.

I need to display the data in a line graph. Thank you

1 Reply

  • ribisht17's avatar
    ribisht17
    Super User
    3 years ago

    Hi Syndicate_Admin   

     

    Create a relationship manually

    1. On the Modeling tab, select Manage relationships > New.

    2. In the Create relationship dialog box, in the first table drop-down list, select a table. Select the column you want to use in the relationship.

    3. In the second table drop-down list, select the other table you want in the relationship. Select the other column you want to use, and then select OK.

      Please see this link > Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

       

      Thanks,

      Ritesh