Showing visual in different timezone based on slicer selection or RLS

Hi WHENG ,

The place of the max() is the same as selectedvalue(). But max() return the maxnium date in the date column of current row Event ID, For example, event id is I-0001 and it has one rows in events table, which row's date has one value 1/1/2022 4:00pm, so the max() date is 1/1/2022 4:00pm, it returns 1/1/2022 4:00pm. But if this event-id has two rows, it will return only one of them.

change the chart visual (e.g line or bar) as well according to the selected Timezone too

Please provide the measure of count. Or some measure like this:

measure =
VAR _switchtime =
    SWITCH( TRUE(), "Asia/Singapore", 8, "Asia/Bangkok", 7, 0 )
RETURN
    COUNTROWS(
        FILTER(
            'event table',
            ( [start date] - _switchtime )
                <= MAX( calendar[date] )
                && ( [start date] - _switchtime )
                    >= MIN( calendar[date] )
        )
    )

item 3# RLS:

get the default timezero =
VAR _d =
    CALCULATE(
        MAX( 'usertimezero' ),
        FILTER( usertimezero, [useremail] = USERPRINCIPALNAME() )
    )
VAR _a =
    SWITCH(
        _d,
        "Asia/Singapore", CALCULATE( MAX( SGT[Start date] ) ),
        "Asia/Bangkok", CALCULATE( MAX( THT[Start date] ) ),
        CALCULATE( MAX( UTC[Start date] ) )
    )
RETURN
    IF( SELECTEDVALUE( Timezone[Timezone] ) = BLANK(), _a, [Start date] )

if you need more help , you can share pbix file without sensitive data.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.