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
Anonymous
Not applicable

YTD based on latest value of slicer

Hi,

 

I have a one pager with week based information. 

 

Report charts

  • KPI Chart --> Last weeks sales
  • KPI Chart --> YTD Sales (from week 1 to current week)
  • Line chart --> Week over week sales 
  • Matrix / Bar charts --> Information about 1 specific week

 

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.

 

1 REPLY 1
amitchandak
Super User
Super User

@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

https://youtu.be/WSeZr_-MiTg

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.

Top Solution Authors