How to plot week-by-week total based off a count of a logical IF in bar plot for dashboard?

[ninos-shiba]

Hello Power BI community,

I've tried looking everywhere on the web for help with this issue but I can't seem to find a solution. Basically, I have a CSV file that I want to use to create a bar plot for a dashboard that I want to show the total number of late assignments each week, up to the current week. I created a IF column: "

LATEORNOT = IF(DATATABLE[FINISHDT].[Date] < TODAY(), 1, 0)", which returns 1 if the assignment is late. I also created a WEEKNUM and WEEK column, but of course those only return the week of the date the assignment is reported. How do I plot all the weeks of the year up to the current week of the year, counting up all the late assignments up to that week and plotting each week's totals as a bar plot in Power BI? Right now, if I plot them, I only get the weeks of the ones in the CSV file (Week 17, Week 20, Week 21, Week 28, etc.). Do I need to have data for each week or? I'm sorry if this is confusing, please let me know if I could provide any further clarification.

[parry2k · Accepted solution]

@ninos-shiba choose show items with no data as shown below 

[ninos-shiba]

@parry2k Thank you! However, it still doesn't show all the weeks in the year up to the current week (32).