Forum Discussion
Power bi Service
Hi Anonymous
To auto-select the latest month in a slicer in Power BI Service:
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
Hi Anonymous
To auto-select the latest month in a slicer in Power BI Service:
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
User can Select the past month also when he open the drop down but when He refreshing the link or open the link in Service , Slicer should Automatically select the Latest month .