Forum Discussion
Building a table distributing status and points
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!
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!