Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
6 | |
6 | |
6 | |
6 |
User | Count |
---|---|
9 | |
9 | |
8 | |
6 | |
6 |