Dynamic display selected date and last week date in the header

[H_insight]

Hiya,

I’m currently working on a Power BI report and facing a challenge with creating a dynamic header that updates based on slicer selections (Day of Week). Specifically, I want the header to dynamically display the selected date and the date one week prior.

The goal is to have the below output, based on selecting Monday as day of week and current month of May 2024 (06/05/2024).

Here is a link to the sample file.

Thank you

[lbendlin · Accepted solution]

In such scenarios your slicer needs to be fed from disconnected tables,