Forum Discussion

DM0010's avatar
DM0010
Regular Visitor
3 years ago
Solved

Combining multiple tables in one visualization

Hello everyone!   I recently started to use Power BI at my work for more insightful visualizations of certain financials. I'm getting to know the program by watching (and reading) a lot of tutorial...
  • NikhilChenna's avatar
    NikhilChenna
    3 years ago

    Hi DM0010 , it is simple. if all the tables column names are same.
    1. Go to Power Query Editor select all the tables from your left hand side queries pane using Ctrl. 
    2. After that click on Append Queries button (Combine section) above ribbon . Attaching screenshot for your reference.

    3. Refer this link too for more details ,
    https://learn.microsoft.com/en-us/power-query/append-queries

     

    Regards,
    Nikhil Chenna 

     

    Appreciate with a Kudos!! (Click the Thumbs Up Button)
    Did I answer your question? Mark my post as a solution!

     

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi DM0010 ,

 

What is the connection mode of your data?

If you can't use power query, maybe DAX could help you. Could you please provide a simple sample about your data? 

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.