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

[Stevenrizado]

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 · Accepted solution]

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.