Forum Discussion
Visualization Actual vs. Forecasted Values
Hi Lucas1006
Are the actual values and forecasted values in one column?
It's difficult to get the outcome without detailed description.
Could you please share your data(exclude sensitive data), or create some sample data, so that we can help you better.
You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey Zhengdong Xu, thanks for your Reply!
For sure i can share a picture of Sample Data! Please see below:
This is one of the Tables for one of our Entities. As you can see here, you have on the Left Side the total Cost which is the end result of the costs summed up of the Cost Categories below. (I renamed them since i dont know if this would be too sensitive). In the colums that are marked red you can see the cells named "ACTR" - these are my actual Values. The 001, 002, etc. is standing for the month number. The cells marked in blue with the name "F02" means that these are my forecasted values of each month.
Best Regards
Lucas