cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Slicer Default Stopped Working

Hello Everyone,

 

My slicer has randomly stopped working. I have not updated the file in nearly 6 months.

 

My report is a weekly report. The slicer lists the last day of each report in a drop down. There is also a "Most Recent" which shows the last full report. The code for this is below:

 

Dropdown selection = IF (
    [End of Week]
        = CALCULATE (
            MAX ( Alarms[Alarm Received Date] ),
            FILTER ( ALL ( alarms ), WEEKDAY ( Alarms[Alarm Received Date], 1 ) = 7 )
        ),
    "Most Recent",
    FORMAT ( [End of Week], "yyyy-mm-dd" )
)

 

For example, the slicer on 1/5/2021 should be:

 

1/9/2021

Most Recent

12/26/2020

12/19/2020

12/12/2020

etc...

 

Unfortunately, it is currently showing the following:

 

1/9/2021

1/2/2021

Most Recent

12/19/2020

12/12/2020

etc...

 

It looks like the "Most Recent" field stopped updating once we hit 2021. I can't seem to figure out how or where to fix this. Any idea's what I am missing?

3 REPLIES 3
Super User IV
Super User IV

@ShaneL79 , Check what is MAX ( Alarms[Alarm Received Date] ) date you have. I doubt data is not coming properly. That could be the reason. The formula seems fine.  Seem like you are not getting data for 2021 for Alarm Received Date

 

or you table has some missing dates



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@amitchandak, the last whole report date was 1/2/2021, but the Alarms[Alarm Received Date] does not have a record on that day since there were no alarms on that day. A day without an alarm is extremely uncommon (maybe 1-2 times a year), so it falling on a date that defines the end date of a report makes sense since it has no way to compare that. I guess I will have to wait until this weekend to see if it updates properly. 

 

Thanks for giving me a place to start looking.

 

Super User III
Super User III

@ShaneL79 share all the measures, what is END OF WEEK measure?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors