Drill down by Week
Results 1 to 2 of 2

Thread: Drill down by Week
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Drill down by Week

    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
    Last edited by Fluff; Jul 23rd, 2019 at 01:37 PM. Reason: removed failed image code

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Drill down by Week

    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-p...lendar-tables/

    ps. You need to sort out your image posting
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •