Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a one pager with week based information.
Report charts
Currently experiencing some challenges:
I have made two slicers, the first one is for the Week over week performance, manually select the first week and last week. I prefer to make it dynamic for the last 10 weeks (based on the week of the other slicer, which is the last full week)
The second slicer is being as last week, to show the users the performance of that given week. As I am reporting on Mondays the Monday sales are already included in the data set, and will be shown in the YTD KPI Chart. Preferably these sales will be shown in the next weeks report.
Long story short:
Is it possible to use 1 slicer were you can select the first week and last week, where you are able to show values of the last week in some charts, and YTD in a KPI chart ignoring the 1st week of the slicer as I always want to show YTD from 1st day of the year untill latest value.
I want to prevent adding multiple slicers as it would obstruct user experience.
@Anonymous , If selected a week or defaulted on date/week, these should be able to help you
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
If you need 2 slicers
How to use two Date/Period slicers
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |