Forum Discussion
How to leave out date from visuals interaction
I don't see a way to do that on page, but it should be possible as either a drillthrough or hover help. As long as any filters on the primary date table are not passed through then you could build the visual using columns from the previous dates table.
Thank you johnt75, that's an interesting technique. But it looks pretty advanced while too different from my scenario. In the video, all is based on a date in a slicer. In my case, the date is what should be ignored. Also, I want to keep the interactivity in the opposite direction as well - for a selected datapoint in A) show a client detail in B). I'm affraid I'll be unable to amend this to fit my purpose.
johnt75Super User
My thinking was by treating the date column in your table visual as the slicer from the video you would then use the previous dates table in your line chart, so when you select a row from the table visual all filters would then be applied to the line chart. You can intercept the max date from the table visual and use that to manipulate which dates from previous dates get shown.
I implemented the solution, but the result is only half-satisfactory. The table now filters the chart correctly, but the chart doesn't filter the table at all anymore, since the connection between the two date tables is a single direction inactive one. So I'm paying for the new feature by losing the capability to analyze the chart's history. I'm considering the trade-off but still hope I can somhow have the best of both worlds.
- johnt75
I don't see a way to do that on page, but it should be possible as either a drillthrough or hover help. As long as any filters on the primary date table are not passed through then you could build the visual using columns from the previous dates table.