Forum Discussion
Selective filters- Limiting interactions to specific fields?
I seem to have found a partial solution by accident, so sharing here (since Googling found no solution earlier):
Change the Table to a Matrix and click the arrow at the top to turn Drill Mode on.
Caveat: You have to have multiple fields set as the Rows, and you can't filter using the bottom layer.
For example, I have Category, Subcategory, and Item - I can click the Category or Subcategory, and the Line Chart will filter to only show that category/subcategory, but clicking Item will not filter the Line Chart to that item.
Fortunately, this is good enough for now, but if there's any recommendations on how to get it down to that bottom level, I'd still appreciate the help!
Advocate IHi, I think I get what you're saying.
I'm sure there are multiple ways to do this, but my solution would be to create a measure for the rolling 6 month value. That way, when you click the item in the week, you're not seeing just that week's sales in the other chart, you're seeing the 6 month trend for whatever item you've selected.
It's hard to say specifically what that measure would look like, but it would be a CALCULATE() where the filter forces it to use the 6 rolling months.
This would give you two measures, the one in your table you click, and another one in the chart for rolling 6 months value, disregarding the week date.
Thanks, RyanAck. The concern I have with that solution is that a Measure would still only give me one value, unless I create measures for Last Month, The Month Before, Two Months Before, etc.
Since I want to be able to use the filtered data in a line graph, I need to preserve the date filter instead of creating a custom measure.