Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Timo1980
Advocate I
Advocate I

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. outcome.jpg

 

1 ACCEPTED SOLUTION

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

View solution in original post

6 REPLIES 6
v-gizhi-msft
Community Support
Community Support

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:

30.PNG 

 

Best Regards,

Giotto Zhi

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.

 

 

filter.png

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

Hi,

thanks for sharing, i found the problem, seems it did not work for when the tables were connected. I removed the connection and now it works. Thank you! for your help....much appreciated.

Timo1980
Advocate I
Advocate I

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.