Filter visuals to show only years equal or previous to whats in Play Axis

[Sab]

Hello!

I have a table with a Year column and some other columns like Visitor Volume. I want to create a measure to put it as a Page Level filter to show only years equal or previous to what's in the Play axis.

For example, If the Play Axis is on 1974, the chart will show bars for 1970, 1971, 1972, 1973, and 1974 with their actual values. When the play axis is on 1975, then another bar is added to the column chart for that year, etc.

Thanks!

[Sab]

This looks like a job for Superman @AlbertoFerrari  🤔

[Ashish_Mathur]

Hi,

I am not sure whether this will work with a play axis but you may refer to my solution to a similar problem in the attached files.

[Sab]

I changed your slicer to Play Axis, and it doesn't work 😞

[Sab]

@amitchandak any idea about this bro?

[lbendlin]

You will need to use a disconnected table for the years and the standalone play axis visual.  This will not work with the built-in play axis.

Edit: The standalone PlayAxis visual is highlighting, not filtering.  Not a good UX.

[Sab]

thanks for the reply, I have a disconnected table and I disabled the play axis interaction with the chart, now I need to tune the measure. This one doesn't work:

Visitors =

CALCULATE(

    SUM('MainTable'[Visitor Volume]),

    FILTER(

        ALL('MainTable'),

        'MainTable'[ Year] <= MAX('DisconnectedTable'[ Year])

    )

)

Can you help on this?

[lbendlin]

No, I don't think what you want to do is possible, nor do I think that it provides any value for your users. Go back to the drawing board and figure out what you actually need to achieve.

[Sab]

If you think it's not possible, that's fine. But it's not for you to decide whether that functionality brings value to my users or not.

Thanks again!