Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Combine Multiple Fields in a Slicer

Hello, I am quite to Power BI. Consider the below Excel where we have 4 employees and their monthly/weekly work status. I am trying to create a dashboard as seen in the second image. I have a proble...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

OK, what does it mean that a person has worked 42 hours on this "Project A, Project B, Project C, Project D"? How do you want to allocate 42 hours to the individual projects? If there are no weights assigned to the projects, then the only sensible allocation is just a simple division of the hours among all the projects. Right?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I have work hours data against each project for every person. I need to accommodate that part here in this excel.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    OK. So why are you not showing this part here? This is an integral part of the problem and you're keeping it away...

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      These individual hours are coming from odd sources so I just put them together like this. Maybe not the best way. Splitting the Projects column in Power BI with a delimiter seems to be only static because the number of projects may vary.

       

      EmployeeWork HoursLeave HoursWeek NumberProjectsProject Hours
      John3481Project A, Project B20+14
      Derek4201Project C42
      Michael4201Project B, Project C30+12
      William4201Project C, Project D20+22
      John4202Project D42
      Derek3482Project A, ProjectB30+4
      Michael4202Project B, Project C20+22
      William4202Project A, Project B, Project C, Project D10+10+10+10+2
      John4203Project C, Project D30+12
      Derek4203Project B, Project C, Project D10+10+22
      Michael26163Project D26
      William4203Project D42
      John4204Project A, ProjectB30+12
      Derek3484Project C, Project D20+14
      Michael4204Project D42
      William4204Project B, Project C20+22
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        It does not matter that the number of projects can vary. Power Query is powerful enough to handle this gracefully but it might require some intervention in the M code. I want to see the raw data that you get, not data after "some processing". I bet you don't get data in the form "20+22+32."