Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Summarizing values in table visualization

I have the following tables (abbreviated):

Resources.ResourceNameResources.Hours
Resource 140
Resource 120
Resource 110
  
Projects.ProjectName 
Project 1 
Project 2 
Project 3 

 

And would like to create a PowerBI table visualization that looks like this, summarizing project count and project hours but keeping the detail :

BI TABLE VISUAL    
Resources.ResourceNameSummary HoursProject CountProjects.NameResources.Hours
Resource 1703Project 140
Project 220
Project 310

 

Thought this would be simple, but am struggling as a leyman PowerBI user.  Any suggestions? 

Much appreciated...

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Sorry, editor didnt like the HTML tags, here is an image of the table visualization:

     

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous,

     

    Could you show the logic of how to achieve the output visual from the original table? For example, why in Resources.ResourceName, the values are Resource1?

     

    Community Support Team _ Jimmy Tao

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