Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
Heed help of Dynamic Title based on date range filtered in slicer.
For example, if i select the date range as from 01/04/2019 to 15/04/2019 then the title should display as
"Sales report for the period 01/04/2019 to 15/04/2019".
My sales data is as follows
Sale Date | Item | Units | Total |
01/04/2019 | Pencil | 95 | 189.05 |
02/04/2019 | Binder | 50 | 999.5 |
03/04/2019 | Pencil | 36 | 179.64 |
04/04/2019 | Pen | 27 | 539.73 |
05/04/2019 | Pencil | 56 | 167.44 |
06/04/2019 | Binder | 60 | 299.4 |
07/04/2019 | Pencil | 75 | 149.25 |
08/04/2019 | Pencil | 90 | 449.1 |
09/04/2019 | Pencil | 32 | 63.68 |
10/04/2019 | Binder | 60 | 539.4 |
11/04/2019 | Pencil | 90 | 449.1 |
12/04/2019 | Binder | 29 | 57.71 |
13/04/2019 | Binder | 81 | 1,619.19 |
14/04/2019 | Pencil | 35 | 174.65 |
15/04/2019 | Desk | 2 | 250 |
16/04/2019 | Pen Set | 16 | 255.84 |
17/04/2019 | Binder | 28 | 251.72 |
18/04/2019 | Pen | 64 | 575.36 |
19/04/2019 | Pen | 15 | 299.85 |
Thanks in advance.
Best Regards,
Shib
Solved! Go to Solution.
This should work for you:
Hi,
I think this answer is only correct if the data in Sheet1 has a record for the filtered start and end date so it does not give the correct result if we filtered from 1-Sep-2021 to 17-Sep-2021 and Sheet1 only contains data from the 2-Sep-2021 to 16-Sep-2021 as this would give the results of " Sales report for the period 2-Sep-2021 to 16-Sep-2021" .. which is clearly not show the filtered date range.
This should work for you:
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |