Planned Vs Actuals Chart

[Anonymous]

Hi Good Morning

I have a table containing Plan and actuals for that month and also cumalative for that month. I also have a date table and I wish to have a Line Chart for Monthly Plans and Actuals. Also my table has  the information for 

My Date table contains 

I am unable to get a line Chart for Each Month what is Actual and Plan 

Can Some one help me please.

Banda

[v-cgao-msft · Accepted solution]

Hi @Anonymous ,

Not sure. Please try creating a line chart using 'Date' [Month] as the x-axis, 'Table' [Mth Actual] and 'Table' [ Mth Plan] as the y-axis. In this case make sure that there is a one-to-many relationship between the 'Date' table and the 'Table' table so that the 'Date' table can filter the data in the 'Table' table properly. Otherwise, please consider using 'Table' [Month] as the x-axis.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[grantsamborn]

Hi Banda

The following links will help get your questions answered faster:

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523