Forum Discussion
Condition slicer
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
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