Dynamic Subscription with a dynamic date based on schedule refresh

Hi jaktony ,

Unfortunately, Power BI does not directly allow dynamic slicer values in subscriptions i.e., you can't have the slicer itself change dynamically based on the subscription schedule. However, there are a few workarounds to achieve similar functionality:

Use a DAX Measure for Dynamic Filtering Based on Current Month

Create a Dynamic Measure for the Month Filter:
You can write a DAX measure to calculate the data for the current month or the month of the subscription:

CurrentMonthData =
CALCULATE (
[YourMeasure],
YEAR('Date'[Date]) = YEAR(TODAY()) && MONTH('Date'[Date]) = MONTH(TODAY()))

Instead of using a slicer, you can apply this measure to your visuals to show data only for the current month. This way, when the report is generated in October, it will automatically filter to show only October data.
The subscription will run according to the scheduled time e.g., the first of the month. Since the DAX measure dynamically adjusts to the current month based on the system date (TODAY()), it will always reflect the month corresponding to the subscription schedule.

Hope this helps.
Chaithra E