Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
101 | |
75 | |
63 | |
62 |
User | Count |
---|---|
141 | |
104 | |
101 | |
80 | |
67 |