Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have an expense/budget table where descriptions are listed by column and yearly/monthly actual, forecast and budgeted financial information as headers as shown below:
Region | Team | Project | FY23 Actual | 202301 | FY24 Actual | 202401 | .... |
Japan | Team 1 | Project 2 | 100 | 50 | 200 | 100 | |
USA | Team 2 | Project 1 | 200 | 70 | 400 | 60 |
and so on... the column headers continue on for each month for the fiscal year. The values in each yearly/monthly column is a financial value.
I'm trying to graph and create visuals where the x-axis would represent said years / months and the financial sum / calculations are plotted as Y value.
Is there a way to do this?
Apologies if this is solved somewhere else but any direction would be greatly appreciated!
Solved! Go to Solution.
in pq ,select the first 3 column and unpivot others. then all the date data will be in one column
not sure what's the expected output based on the sample data you provided. Hope this can help to point the right direction for you.
Proud to be a Super User!
in pq ,select the first 3 column and unpivot others. then all the date data will be in one column
not sure what's the expected output based on the sample data you provided. Hope this can help to point the right direction for you.
Proud to be a Super User!
you are welcome
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |