Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Graph deleting weeks without data

Re: End of Week DAX for non standard workweek: Mon - Sun Thursday Is there a method to display weeks if no data exists for that week?  I need to show a bar graph with totals by week...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    the best practice to tasks like your is to create dimension calendar table. like

    Calendar Table = CALENDARAUTO()

    then you need to add a calculated column in this Calendar Table

    Week = FORMAT('Calendar Table'[Date], "YYYY-WW")

    then create relationships 'Calendar Table'[Date] - [Date] 

    then add 'Calendar Table'[Week] as Axis value

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    LinkedIn

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

the best practice to tasks like your is to create dimension calendar table. like

Calendar Table = CALENDARAUTO()

then you need to add a calculated column in this Calendar Table

Week = FORMAT('Calendar Table'[Date], "YYYY-WW")

then create relationships 'Calendar Table'[Date] - [Date] 

then add 'Calendar Table'[Week] as Axis value

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I will have to work through this as I have not tried this before.  Thank you for the idea and it will likely make future iterations of date-related charts easier.  Thank you for your reply!  Dave in Memphis.