Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
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 👍
Proud to be a Super User! | |
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,
User | Count |
---|---|
85 | |
84 | |
67 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |