Forum Discussion

Stevenrizado's avatar
Stevenrizado
Frequent Visitor
8 years ago
Solved

How to: Matrix / Column chart showing FTE data per department instead of grand total

Hi everyone,

 

I just met Power BI a few days ago and as a newbie I'm stuck on something which, at first sight, looks very simple.

Below is a dataset of different departments which I would like to put on my axis, and have some form of column chart (or matrix) in which Budget / RFQ / Actuals are aligned for each of the departments.

 

 

However, when I put the data together, this is my result:

Instead of giving me a nice overview of the different Budget / RFQ / Actuals per department, I'm getting a sum of all numbers included in the column.

 

What am I doing wrong? I've tried creating custom columns with the same information and tried creating a filter through 'edit queries'. After that, since I'm completely new and possibly undereducated in the software, I've spent my time pressing buttons hoping I hit a wondrous button.

  • Floriankx's avatar
    Floriankx
    8 years ago

    Hello,

     

    first of all you should Unpivot your Month Columns to have the following columns:

    Department; Budget/Actual; Date; Value

     

    Then you can create a SUM([Value]) and put it in your Pivot.

    Then add your department to row content and Budget/Actual to column content.

     

    Then you can add date filter or slicer or create timelines.

1 Reply

  • Floriankx's avatar
    Floriankx
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hello,

     

    first of all you should Unpivot your Month Columns to have the following columns:

    Department; Budget/Actual; Date; Value

     

    Then you can create a SUM([Value]) and put it in your Pivot.

    Then add your department to row content and Budget/Actual to column content.

     

    Then you can add date filter or slicer or create timelines.