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.
User | Count |
---|---|
81 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |