Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |