Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

Slicer to automatically unselect previous fiscal and only select current fiscal

Hello Community,

Question was asked here,

https://community.powerbi.com/t5/Desktop/How-to-show-set-slicer-to-current-month/td-p/83302

 If I publish in July, my month slicer will only show Jan through July at the time of the publish.  I choose July in my slicer, publish, and that is what is in the service.  In August, July is still the selected slicer option, so the visuals are based on last month, not this month.  Only fix is to open the desktop, refresh, choose new month, republish. 

Can any one has any suggestion?

Thanks

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@tejapowerbi123 , Create a column like this in your date table and select this month. It will make sure it always this month

 

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

 

Sort it on

Format([Date],"YYYYMM")

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@tejapowerbi123 , Create a column like this in your date table and select this month. It will make sure it always this month

 

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

 

Sort it on

Format([Date],"YYYYMM")

Hi Amit,

Thank you so much for your suggestion.

User does not wants to see "Current Month" as a selection that's the issue.Otherwise solutions is working perfectly fine.

Thanks

Greg_Deckler
Super User
Super User

@tejapowerbi123 - Hmm, general solution to something like this is to create a column in the dataset that has a value of 1 for the current month and 0 otherwise. You can then filter/slice on 1. But, this isn't the most user friendly.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.