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,
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?
Solved! Go to 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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
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.