Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

PowerBI - connecting similar tables

I am trying to build a visualization tool for my work, but I'm new to PowerBI and am having trouble understanding the logic for connecting similar tables with different information. My problem is as ...
Need Help
v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

 

To create a visualization that compares the different entities in your multi-tab Excel sheet, you can follow these steps:

  1. Append the tables: In Power BI, you can use the Append Queries feature in the Power Query Editor to combine the tables from different tabs into a single table. This will create a new table with all the rows from the original tables, and you can add a new column to identify the entity each row belongs to.

  2. Create relationships: If necessary, create relationships between the appended table and any other tables in your data model. You can use the Manage Relationships dialog to create new or edit relationship

If these two tables do not have any relationship between them, your visual won't know how to display your data together.

For more details, please refer to:

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

 

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.