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.
Power BI Community,
I am trying to create a visual (clustered column chart) that shows actuals and forecasted values by month. The table I has contains the following information:
(Each saving is one item with the following data)
Savings Name
Start Date
End Date
Actual annual savings
Forecasted annual savings
Can I do this with the data I have? I am not sure how to take the annual savings a break it up by month.
Thanks,
Tim
Solved! Go to Solution.
Hi,
Please download my PBI file from here.
Hope this helps.
Hi,
Share data in a format that can be pasted in an Excel file.
I think I need to use measures but I not sure what the function would be.
Below is an example of the data I have:
Name | Annual Savings | Monthly Savings | Start Date | End date |
AV Savings | $ 120,000 | $ 10,000 | 1/1/2019 | 12/31/2019 |
Housekeeping Savings | $ 20,000 | $ 1,667 | 3/1/2019 | 2/28/2020 |
Lab Savings | $ 11,000 | $ 917 | 4/1/2019 | 3/30/2020 |
How can I get a measure to take the monthly savings and divide by month using the start and end date, and then add all the savings that occur in each month. For example, the clustered column would have $10k for January 2019, $10k for February, $11.6k for March, and $12.5k for April. I also want to function to not add the monthly savings for a particular project after the end date is reached.
Thanks,
Tim
Hi,
Please download my PBI file from here.
Hope this helps.
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |