Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Power bi Service

Hi Power bi Team, When we refreshing in Power bi  in service , Month should automatically selected latest month in the Slicer. When Some one visite the power bi service click on Link latest month au...
Need Help
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    Hi Anonymous 

    To auto-select the latest month in a slicer in Power BI Service:

    1. Add a Column: Create a calculated column in your date table.

     

    IsLatestMonth = IF(FORMAT('Date'[Date], "YYYY-MM") = FORMAT(TODAY(), "YYYY-MM"), 1, 0)

     

    • Set a Slicer: Use the "Month" field in a slicer and enable Single Select.

    • Apply Filter: Add a visual-level filter to the slicer: IsLatestMonth = 1.

    • Publish: Save and publish the report. After refresh, the slicer will auto-select the latest month.

     

    Did I answer your question? Mark my post as a solution, this will help others!

    If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

    Kind Regards,
    Poojara
    Data Analyst | MSBI Developer | Power BI Consultant
    Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

v-prasare's avatar
v-prasare
Community Support
1 year ago

Anonymous,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our community members helps you? or let us know if you need any further assistance here? 

 

Your feedback is important to us, Looking forward to your response.

 

Thanks,

Prashanth Are

MS Fabric community support.

 

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos"