Daily Backlog Work past 30 Days

Question

Hi all, I've been trying to find a simple solution for the past couple days, and can't seem to find one. I need more eyes to figure this one out.&nbsp;I have a table (tblWT) with 3 different types of work that needs to be done within a certain time.Here are the headings:WorkType | Effort Days | Date Assigned | Date Due | Date Completed&nbsp;I created a Date table using DAX:BacklogMeasures = CALENDAR(NOW()-30,NOW())&nbsp;In my Date table I can calculate the Effort Days, and have the followings as an example:Work1 Backlog Completed = SUMX(FILTER(tblWT,tblWT[Date Assigned]&lt;=BacklogMeasures[Date] &amp;&amp; tblWT[Date Completed]&gt;BacklogMeasures[Date] &amp;&amp; tblWT[Due Date].[Date]&lt;BacklogMeasures[Date]) &amp;&amp; tblWT[Worktype]="Work1",[Effort Days])&nbsp;And the results on my Dates table:Date | Work1 Backlog Completed | Work1&nbsp;Backlog&nbsp; | Work2&nbsp;Backlog Completed |&nbsp;Work2 Backlog | and so on4-1&nbsp; &nbsp; &nbsp; 54&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 28&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;47&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;123-31&nbsp; &nbsp; 28&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;58&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;42&nbsp;3-30&nbsp; &nbsp; 31&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;42&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18&nbsp;How can I use only one visualization (Line Chart) to show all 30 days and one Worktype at a time with a slicer?I think the way it is done, I would need 3 visualizations to show my 3 kinds of Worktypes.Any way around this?&nbsp;Thanks,&nbsp;XP

v-lianl-msft · Accepted Answer

Hi Xpender&nbsp;,&nbsp;It is very difficult to analyze without looking at the data and just by imagining. See if you can paste the image of the table representing any sample data or share the sample pbix via cloud service(OneDrive for business).Based on your description, you want to change the properties of measure according to the slicer. You can refer to this blog:https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/&nbsp;&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Daily Backlog Work past 30 Days

1 Reply

Related content

Daily trend with backlog showing

Storage increasing daily

Backlog Calculation

backlog issue in eventstream

Historical Backlog Snapshots in Microsoft Fabric - SQL vs PySpark