Forum Discussion
Sparkline shouldn't interact with Week Filter
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
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.