Sparkline shouldn't interact with Week Filter

[likhitha2705]

Hello All,
        I've a Week Filter on the report and I've a matrix visual in which i'll be showing sparkline by week.The sparkline shouldn't interact with week selection filter.Edit Interactions isn't the choice and I've (L4 W,L12 W,L26 W,L52 W and YTD) but in sparkline I want to show only (L4 W,L12 W,L26 W and L52 W).How to achieve that?

These 2 matrix visuals should be in a single visual.
TIA

[Anonymous · Accepted solution]

Hi @likhitha2705 ,

For Sparkline, it is possible to fix the specific time and write it in the measure so that it will not be affected by external filters.

You can try formula like below:

by_date =
CALCULATE (
    MAX ( 'Table'[Value] ),
    ALLEXCEPT ( 'Table', 'Table'[Product] ),
    'Table'[Date]
        IN { DATE ( 2022, 01, 01 ), DATE ( 2022, 02, 01 ), DATE ( 2022, 03, 17 ) }
)

Best Regards,
Adamk Kong

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