Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to Solution.
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
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-...
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/1447...
Having 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 | |||||||||||
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
13 |
User | Count |
---|---|
91 | |
85 | |
46 | |
28 | |
21 |