Table in picture relocated to Power BI?

[TANA]

Hi,

I am working on projects. And we have progress reports every month. The format of partial progress report in excel for one project is like the image above. Our target is to have them shown dynamically in Power BI with filters. When you select different projects in the filter, the table will automatically be updated with different information in cost and comment sections. By the way, the comment is also retrieved from excel, which can be long text. Can you give me help on making it happen? Thanks, appreciated!

[Idrissshatila]

Hello @TANA ,

So what you should do as a start is to import the excel sheet into Power BI, refer to this inorder to see how https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-excel-power-bi-datasets

Then You can display the data into  Matrix visual ( Which is a table visual) refer to this to learn more anout matix https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

It's pretty mucb simple in your case.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[TANA]

Thanks so much! I will give it a try. 

By the way, for comment area which could have long text, any suggestions you have? I might think that may not fit well with matrix visualization, what do you think? Thanks,