Dynamic Slicer & Histogram

Hi j_gan2022 

The first thing to note is that tables created by new table cannot interact with the slicer in the page, in other words, the table is created statically.

In other words, the table is created statically, so we can only create tables in measure to make them dynamic.

The first step is to prepare the x-axis and what if slicer (last n day table)

X-axis = GENERATESERIES(0,200)

The second step is to create a measure like the one below.

Measure =
VAR _what_if_n_day =
    SELECTEDVALUE( 'Last n day'[Last n day] )
VAR _last_day =
    TODAY()
VAR _last_n_day_table =
    FILTER( 'MY_TABLE', [Attendance Date] >= _last_day - _what_if_n_day )
VAR _summarize =
    SUMMARIZE(
        _last_n_day_table,
        [Student ID],
        "Number of Attendance", COUNTROWS( 'MY_TABLE' )
    )
RETURN
    COUNTROWS(
        FILTER(
            _summarize,
            [Number of Attendance] = SELECTEDVALUE( 'X-axis'[Value] )
        )
    )

Pbix in the end you can refer.

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.