shift Number should change automaticlly in slicer

Hello SSBkrish , 

You can create the below table with shifts and add it as slicer..then write the below DAX to get the result.

Shift Number Start Time End Time

Current Shift =
VAR CurrentTime = TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW()))
RETURN
SWITCH(
TRUE(),
CurrentTime >= TIME(8, 0, 0) && CurrentTime < TIME(16, 0, 0), "1st Shift",
CurrentTime >= TIME(16, 0, 0) && CurrentTime < TIME(22, 0, 0), "2nd Shift",
"Outside Shifts")

please make sure your report is refreshed becasue without report refresh your shift timings wont change.

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

Hi SSBkrish 

You can leverage the Group By Columns property (accessible using Tabular Editor)  to store a fitler by using an alternate value. You can create a calculated column that check the current time and compare it agains the the shift column. For example

CurrentShift =
IF (
    UTCNOW () + DIVIDE ( 8, 24 )
        >= DIVIDE ( 16, 24 )
        && 'table'[shift] = "4PM AM to 10 PM",
    1,
    0
)
-- 8 means GMT+8, change it to your timezone.

Use the above calcualted column in the Group By Colums property.  Please note that calculated columns do not update unless the underlying reference table/column updates so the value of UTCNOW() is based  on the latest refresh. That said, you need to refresh your semantic model after 4PM so that value updates as well. Here's an example of how that column property is leverage. Further reading can be found in the video description, including its current limitations.

https://www.youtube.com/watch?v=MrEAZREQuXM