Building a table distributing status and points

[ZodtePt]

Hi,

my manager is used to seeing our activities distributed in a table in the format below, where every column is attached to a person with their activities below their names. Each activity has a status (Done or To be done) and a difficulty point. The activity distribution is also segmented by week.

I already have everything set in my Power BI desktop, but I'm wondering how I could build the same layout that he is used to in Power BI.

Thaks for your help!

[v-jingzhan-msft · Accepted solution]

Hi @ZodtePt 

I agree with @lbendlin that in Power BI it's not possible to build the same layout in a matrix or table visual. The reason is that in a table or matrix visual, all values on the same row are calculated or evaluated based on the row header value. It means it will evaluate a status and point value for every activity and for every person. However, in your original Excel table, there may be multiple activities on the same row because everyone's activity is different. This brings the difference. 

If you want to use Power BI to display these data, you may have to adjust your expected layout. Or you can explore Business Apps – Microsoft AppSource to find if there is any custom visual can meet your need. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[lbendlin]

Power BI is not the right tool for that, not even with paginated reports.  Continue using Excel.