Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
Hi,
I am sorry i haven't shared my test pbix file with you.
Here:
Please check it with your file.
If you still have any problems, please for free to let me know.
Best Regards,
Giotto Zhi
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
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.
Hi,
I am sorry i haven't shared my test pbix file with you.
Here:
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.
TABLE 1 (GI date is the date filter)
GI Date | Product Type | Key |
Tuesday, 17 December 2019 | A | 43816A |
Monday, 16 December 2019 | A | 43815A |
Friday, 20 December 2019 | A | 43819A |
Thursday, 19 December 2019 | A | 43818A |
Wednesday, 18 December 2019 | A | 43817A |
Sunday, 15 December 2019 | A | 43814A |
Tuesday, 17 December 2019 | B | 43816B |
Monday, 16 December 2019 | B | 43815B |
Friday, 20 December 2019 | B | 43819B |
Thursday, 19 December 2019 | B | 43818B |
Wednesday, 18 December 2019 | B | 43817B |
Sunday, 15 December 2019 | B | 43814B |
Below TABLE 2 containing the values
DateProduct TypeKEYValue
Tuesday, 17 December 2019 | A | 43816A | 2 |
Monday, 16 December 2019 | A | 43815A | 4 |
Friday, 20 December 2019 | A | 43819A | 5 |
Thursday, 19 December 2019 | A | 43818A | 2 |
Wednesday, 18 December 2019 | A | 43817A | 7 |
Sunday, 15 December 2019 | A | 43814A | 1 |
Tuesday, 17 December 2019 | B | 43816B | 7 |
Monday, 16 December 2019 | B | 43815B | 0 |
Friday, 20 December 2019 | B | 43819B | 3 |
Thursday, 19 December 2019 | B | 43818B | 6 |
Wednesday, 18 December 2019 | B | 43817B | 8 |
Sunday, 15 December 2019 | B | 43814B | 11 |
Sunday, 22 December 2019 | A | 43821A | 12 |
Saturday, 21 December 2019 | A | 43820A | 3 |
Wednesday, 25 December 2019 | A | 43824A | 7 |
Tuesday, 24 December 2019 | A | 43823A | 2 |
Monday, 23 December 2019 | A | 43822A | 8 |
Friday, 20 December 2019 | A | 43819A | 7 |
Sunday, 22 December 2019 | B | 43821B | 2 |
Saturday, 21 December 2019 | B | 43820B | 6 |
Wednesday, 25 December 2019 | B | 43824B | 9 |
Tuesday, 24 December 2019 | B | 43823B | 9 |
Monday, 23 December 2019 | B | 43822B | 1 |
Friday, 20 December 2019 | B | 43819B | 4 |
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |