Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a line chart by using a column value combined from two table

Hi All,

 

I need to create a line chart based on a column.I have this column in two of my tables.now I want all the values for this particular column from these two tables on a single line.

 

How can I do this.

I know I can Combine these tables in Power Query.

 

Thanks

Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

    You have already answer to your query - appending these 2 tables into a single table in Power BI 🙂

    Then use the column on line chart.

    Just make sure that the column names in both the tables should be same.

     

    Thanks,

    Pragati

  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi, Anonymous 

    If you want to use values from columns in two tables into one single line, you need to create a new table based on these two tables. According to the structure of your tables, you can use Merge or Append in Power Query Editor or CROSSJOIN or Union in Desktop.

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous ,

     

    You have already answer to your query - appending these 2 tables into a single table in Power BI 🙂

    Then use the column on line chart.

    Just make sure that the column names in both the tables should be same.

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Pragati11 Is there any other way something if we can create a measure where it will return the total values of this column from both the tables.Beacause through appending query it creates a new dataset.

       

      Thanks

      • Pragati11's avatar
        Pragati11
        Icon for Super User rankSuper User
        5 years ago

        Hi Anonymous ,

         

        this will completly depend on what you are trying to plot on your line chart.

        Add details and some screenshots on what you are trying to achieve.

         

        Thanks,

        Pragati

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

    If you want to use values from columns in two tables into one single line, you need to create a new table based on these two tables. According to the structure of your tables, you can use Merge or Append in Power Query Editor or CROSSJOIN or Union in Desktop.

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.