Replicate tables help

[Anonymous]

Hi, 

Can someone give me suggestion how to replicate these tables from Excel to Power BI? Thanks, 

[Anonymous]

Hi  @Anonymous ,

May I ask, is the information in your picture a visual created by Excel or a table manually inputted by yourself.

If it is a visual created by Excel, you need to use the "Excel workbook" method to connect to Excel through Power BI Desktop, get the underlying data, and then create the style you need through Visual and Dax in Power BI Desktop. 

If it is a table where the information is entered manually:

For the first method, you can just copy the section of each table in Excel and click Enter data in Power BI Desktop to paste its copied content into Enter data.

The second method is to use the "Excel workbook" method can be connected to Excel through Power BI Desktop.

Note that you need to change the following contents of your Excel, because Power BI will change according to its own data structure after connecting to Excel, for example:

Columns that you merged in Excel are shown as one column on top of Power BI Desktop

Data created by Excel:

Connect to Power BI Desktop:

Best Regards,

Liu Yang

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

[Anonymous]

Thanks for your help! 

May I know which visual I can use to create a similar output as in Excel? Any suggestions? Thanks,