Forum Discussion
Sparklines and Matrixvisual - Remove filter on date
Hi Community,
I have a Matrix Visual containing a sparkline. The matrix-visual is filtered by the date dimension. People filter a particular day in the matrix-visual through a date slicer.
However, the sparkline's x-axis is showing also the date-dimension. I want to see how the measure performs over time compared to the daily value represented in the matrix visual.
If the sparkline would be a separate visual, I would just disconnect the interactions. But I can't do this, because then the matrix-viz itself would be disconnected as well.
How does everyone else solve this problem? Links, ideas, concepts would be highly appreciated 🙂
3 Replies
rks , I doubt that. There is way to remove filters. but that will also show all values on the same date. Independent date table for the axis is an option, but that requires measure level mapping
amitchandak Thank you for your insight. I have never heard of the term "measure level mapping". Are there any blog posts to your knowledge on where to investigate more into this modelling idea?
Best regards,
Konstantin
- Hi everyone, There is only one way to apply remove filter from date in spartline i.e. in case of Trailing 12 Months or Average graph when only one months is selected. Create a new date table, link it with your existing data table 1:1, also link the new date table with the fact table. Now in the sparkline select the MONTHS from the new date table, but the SLICER should be created from the Original date table. By doing so you will see 12 Months graphs in sparkline, even if a single month is selected. @sparkline @remove filter @date issue in sparkline
