The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I want to be able to plot a planned vs. actual on the same timeline, but currently i have to manually filter my graph to the planned start and end dates. This means that any actual that goes onto the graph will put a straight line to the end of the timeline instead of stopping where it is at.
It also means that if i run over scheduele, i have to manually update the end date of the timeline.
Ideally i would like to have a timeline no matter the size, that has two distinct line graphs on it, one showing a linear start-end planned data, and a non-linear day to day actual graph.
Im currently getting this using a simple planned and actual measure,
Modify your measures to return BLANK() outside of the desired date range.