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