Forum Discussion

Lucas1006's avatar
Lucas1006
Regular Visitor
2 years ago

Visualization Actual vs. Forecasted Values

Hello dear Community,   I wanted to raise this topics here right after my first post some hours ago. I've builded a report about the Costs / Volumes that are belonging to my department in my compan...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

  • Lucas1006's avatar
    Lucas1006
    Regular Visitor
    2 years ago

    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