Forum Discussion

Timo1980's avatar
Timo1980
Icon for Advocate I rankAdvocate I
6 years ago
Solved

Show next five days data based on single date filter selection

Hi All,

 

Once again i'm in need of your help. I havent found a solution as yet to my problem. I would like to show the below line graph, of next 5 days worth of data, but instead of using the between slicer, I need it to to show the same output based on a single date selection. So if i would use a date list and select december 14th  the output should visualize the same.

 

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    I am sorry i haven't shared my test pbix file with you.

    Here:

    pbix 

    Please check it with your file.

    If you still have any problems, please for free to let me know.

     

    Best Regards,

    Giotto Zhi

6 Replies

  • Timo1980's avatar
    Timo1980
    Icon for Advocate I rankAdvocate I
    6 years ago

    TABLE 1 (GI date is the date filter)

    GI DateProduct TypeKey
    Tuesday, 17 December 2019A43816A
    Monday, 16 December 2019A43815A
    Friday, 20 December 2019A43819A
    Thursday, 19 December 2019A43818A
    Wednesday, 18 December 2019A43817A
    Sunday, 15 December 2019A43814A
    Tuesday, 17 December 2019B43816B
    Monday, 16 December 2019B43815B
    Friday, 20 December 2019B43819B
    Thursday, 19 December 2019B43818B
    Wednesday, 18 December 2019B43817B
    Sunday, 15 December 2019B43814B

     

     

    Below TABLE 2 containing the values

     

    DateProduct TypeKEYValue

    Tuesday, 17 December 2019A43816A2
    Monday, 16 December 2019A43815A4
    Friday, 20 December 2019A43819A5
    Thursday, 19 December 2019A43818A2
    Wednesday, 18 December 2019A43817A7
    Sunday, 15 December 2019A43814A1
    Tuesday, 17 December 2019B43816B7
    Monday, 16 December 2019B43815B0
    Friday, 20 December 2019B43819B3
    Thursday, 19 December 2019B43818B6
    Wednesday, 18 December 2019B43817B8
    Sunday, 15 December 2019B43814B11
    Sunday, 22 December 2019A43821A12
    Saturday, 21 December 2019A43820A3
    Wednesday, 25 December 2019A43824A7
    Tuesday, 24 December 2019A43823A2
    Monday, 23 December 2019A43822A8
    Friday, 20 December 2019A43819A7
    Sunday, 22 December 2019B43821B2
    Saturday, 21 December 2019B43820B6
    Wednesday, 25 December 2019B43824B9
    Tuesday, 24 December 2019B43823B9
    Monday, 23 December 2019B43822B1
    Friday, 20 December 2019B43819B4
  • v-gizhi-msft's avatar
    v-gizhi-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi,

     

    Please try this measure to replace the original values:

    Measure = CALCULATE(SUM('Table 2'[Value]),FILTER('Table 2','Table 2'[DateProduct ]>=SELECTEDVALUE('Table 1'[GI Date])&&'Table 2'[DateProduct ]<=SELECTEDVALUE('Table 1'[GI Date])+5))

    When you choose one date in list slicer, the result shows:

     

     

    Best Regards,

    Giotto Zhi

    • Timo1980's avatar
      Timo1980
      Icon for Advocate I rankAdvocate I
      6 years ago

      Hi Giotto,

       

      the measure pulls the correct data, but for some reason its only showing the sum on the date. see below. Is there another step i'm missing.