Reduce number of line chart points when using live dataset?

Hi, lehikk 

I'm a little bit confused about your needs. Maybe you need a Measure like this?

Last sixty minutes =

VAR now =

    NOW ()

VAR cur_year =

    YEAR ( now )

VAR cur_mon =

    MONTH ( now )

VAR cur_day =

    DAY ( now )

VAR cur_min =

    MINUTE ( now )

VAR select_date =

    CALCULATE (

        SELECTEDVALUE ( 'Table'[Date] ),

        FILTER (

            'Table',

            YEAR ( 'Table'[Date] ) = cur_year

                && MONTH ( 'Table'[Date] ) = cur_mon

                && DAY ( 'Table'[Date] ) = cur_day

                && (

                    cur_min - MINUTE ( 'Table'[Date] ) <= 60

                )

        )

    )

RETURN

    select_date

Actually, from December 2020, Desktop allows change the connection mode with live datasets from live connection to Direct Query and releases some limitations with live datasets. You can try it.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.