Forum Discussion

Luc__'s avatar
Luc__
Frequent Visitor
3 years ago

Dashboard

Hi everyone,   I try to build a dashboard to provide overview on the spendings within multiple projects. I currently run into the following situation. I have multiple datasets with hour registrati...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

A report/dashboard based on multiple data source is normal. You can use shared dimensional table to visualize the data together, like a shared Date table in your case. If you need further opinion, you can simplify your data and paste the pbix file here. 

  • Luc__'s avatar
    Luc__
    Frequent Visitor
    3 years ago

    Thanks for your response! I can't figure it out, let me describe it in more detail.

     

    I have three tables:

    • A: Table with Project code, project name, project leader, budget
    • B: Project detail Project B with Project code, money spend on task A, B, C, etc.
      • Calculation: SUM of all money spend on the tasks
    • C: Project detail Project C with Project code, money spend on task A, B, C, etc.
      • Calculation: SUM of all money spend on the tasks

     

    Now I want the dashboard to disiplay in the same table:

    • Project codes of all active projects
    • Total money spend on each project
    • Budget of each project

     

    When I am currently displaying the overview table, Power BI creates separate collums for each project instead of combining all the SUM's of each project and placing them in one column next to the according project code.