Select fiscal years in couple

[Anonymous]

Hi all,

in a simple matrix visual I want to display comparative sales figures YoY (or better FY on previous FY). In order to avoid weird results I would like the user to select in a top slicer just one FY and then the system selects that FY and the previous one. Practically the user selects FY22 but the systems understands FY22 and FY21. I suppose there are multiple ways to realise this but any easy one coming to your mind?

Thanks,

C.

[Anonymous]

This is perfect, exactly what I wanted.

Thank you!

Carlo

[v-yinliw-msft · Accepted solution]

Hi @Anonymous ,

You can try this method:

Because I don't know your data looks like, so I create some sample data to test.

The second table is slicer.

Measure =
IF (
    SELECTEDVALUE ( Slicer[FY] )
        <= SELECTEDVALUE ( 'Table'[Year] ) + 1
        && SELECTEDVALUE ( Slicer[FY] ) >= SELECTEDVALUE ( 'Table'[Year] ),
    1,
    0
)

To show all data, I create a index column:

The result is:

Is this what you expect?

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

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