Drill down by Week

[Sandeep3072]

Hi All,

I have a problem with the line chart i,e I am unable to show the data by week wise but I can able to see by day wise. Please help me to show the data by week and day wise like the below screen shot.



Please check the my output:



I used my order data for my axis and I can see by Year,Qtr,Month, and day wise but not by week wise. Is there any work around I can do for that. You may check the below screen shot

 

[Matt Allington]

Are you talking about power BI? Power BI has an auto calendar table, but it doesn’t drill to weeks. You will need to create your own calendar table. You can read my article here.

https://exceleratorbi.com.au/power-pivot-calendar-tables/

ps. You need to sort out your image posting