I am stuck with the below, i want to draw both actual and plan on the same line, each for own color sure, actual vlaues should stop at feb-2020, while plan should be continued till march. garph values is the count of dates in each column. i created a calendar and have a relation ship between claendar[date] & Actual same goes for the plan.
below is how the data looks, also I am searching for support rgearding the running total measure. also i need support in this regard
Solved! Go to Solution.
are they both joined with the calendar. one active and one inactive
Thanks amitchandak for your time, but this is not what i was looking for, topic i was refrred at is amazing, but it is not showing the values on the same line graph, each ctaegory is viewed separetly, i need to present both column values on the same line. Actual values first then line continues to show the planned for the months that have no actual entries
above dropbox link has the data, also a snap inside to how the output should look like, redline is for the actual column, blue line is for the plan. please ignore that dottedblue curve as well as the dashed black line.
thanks for your efforts.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.