Condition slicer

[inawab]

Hi Everyone,

I have a Morring briefing report, but I need it to show weekend operation (Friday, Saturday & Sunday) only on Monday Morring briefing, other days of the week show only 1 day back.

How can I do this?

[BA_Pete · Accepted solution]

Hi @inawab ,

Either in your calendar dimension table, or in your fact table, add a new custom column, something like this:

presentationDay =
if List.Contains({4, 5, 6}, Date.DayOfWeek([date], Day.Monday))
then "Monday"
else Date.DayOfWeekName(Date.AddDays([date], 1))

Use this new [presentationDay] column in your slicer and, when you select the day on which you are presenting, it will select the correct data dates for you.

You will need to filter your report page to only include a single week of data, otherwise you will be selecting the data dates for all history rows that match the day criteria.

Pete