Forum Discussion
Daily trend with backlog showing
I need help with a formula - please!...I have a line chart that shows a backlog of work orders...I'd like to show the total # of backlog orders since beginning but limit it to a daily trend of last 2 years. My data goes back to 2015.
For my running backlog, I used:
You can solve that in two ways
Easy way: use zoom sliders
Hard way: Calculate running total before the selected time range plus running total in the selected time range
3 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Having a hard time entering the data as a table, sorry! This is my dataset...not all data is here as I had to enter it manually but I have dates, created work orders, completed work orders and a running total by day. I'd like to show this as a daily trend capturing the last 2 years of daily activities but limit it to two years and not back to 2015 as seen in data below.
Date Created Completed Running Total by Day 2015/04/14 1 1 2016/12/15 1 2 2018/12/20 1 3 2020/02/21 5 8 2021/01/19 2 10 2021/03/26 3 13 2021/03/29 1 14 2021/07/29 1 15 2021/08/10 1 16 - lbendlin
You can solve that in two ways
Easy way: use zoom sliders
Hard way: Calculate running total before the selected time range plus running total in the selected time range
