Visualization Actual vs. Forecasted Values

[Lucas1006]

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 company that i am working for. The Data Source that we are using contains actual values and forecasted values. The challenge is the following: When i am displaying my costs for example in a Line Graph, the actual and the forecasted values get both displayed in the same line design, what i would like to avoid because for the stakeholders it would be great to have a instant visual understanding of what value is actual and what i forecast... The best solution for me would be to have the actual values in a straight line and the forecasted once as a dotted line. Can someone give me a advice how build this with a simple, fast and efficient solution? Is there any bdp on this? But what i definetely would not like to do is to manualy filter the actual and the forecasted values before publishing the report once in a month. Thanks! 

Best Regards

Lucas 

[Anonymous]

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]

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