How to Auto-Select Latest Month in Power BI Slicer (No Manual Intervention)?

[Maheshbabu1603]

**Requirement: Dynamic Default Month Selection in Power BI Slicer**

I have a Power BI report with a time period slicer built on a hierarchy:
**Fiscal Year → Quarter → Month** (Indian fiscal year: April–March).

* The data is refreshed **monthly**
* Currently, the slicer selection is being **updated manually** after each refresh

---

### **Expected Behavior**

I want to make this process fully dynamic:

* Whenever new data is refreshed (e.g., April data becomes available), the report should:

* Automatically default to the **latest available month** in the dataset
* Reflect this both in the **data displayed** and ideally in the **slicer selection**

---

### **Additional Requirements**

* The logic should be **data-driven** (based on the latest available date in the fact table, not TODAY())
* **No manual intervention** should be required after refresh
* Users should still be able to:

* Manually select other months/quarters/years from the slicer for analysis
* Reset back to the default (latest month)

---

### **Current Setup**

* Date hierarchy is derived using a **Date table related to the Fact table**
* No existing **“current month” or “latest month” flag** is present

---

[v-hjannapu]

Hi @Maheshbabu1603,

I would also take a moment to thank @arvindsingh802  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.

[v-hjannapu]

Hi @Maheshbabu1603,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Community Support Team.

[lbendlin]

Use the filter pane and Relative Date filters.

[arvindsingh802]

You update your month column and update value of your latest month as Value - current month or latest month
Then in your slicer select that value as filter

It will make sure with each refresh currecnt/latest month will selected and the data will be filtered for the same automatically
you can follow https://www.youtube.com/watch?v=JlVHsZUk1nc for step by step tutorial