1 of 1 people found this helpful
Hi Ville: Have you thought about using indicators in your titles/sub-titles, etc? I know Jonathan utilizes this very well in some of his dashboards to show measure filtering.
Here's a very simple example from his blog: Workbook: estimating pi
There are a variety of ways to identify filter selections.I saw in your workbook that you'd hardcoded the # of salespersons, a couple of other techniques to get a dynamic comparison to show what's been filtered and what hasn't are:
- Use a data blend on a duplicated worksheet, with the dimension you want to count not as part of a linking dimension. I figured out a way to use this to return different results based on filter status in this post: Identifying (and Using) Quick Filter Selection Status | Drawing with Numbers.
- Use a table calc filter instead of a filter on dimension or regular aggregate, then you still have all the data underneath to total up in different ways. This can have performance impacts, tho.
We can put measures & dimensions on the Level of Detail and use them dynamically tell stories in the Title, Caption, mark labels, annotations, headers, etc. Also, dimensions on the Filters Shelf can be put into the Title & Caption, to do measures typically what I'll use are things like WINDOW_MIN() and WINDOW_MAX table calcs, get those working, then put them on the Level of Detail and include them in the Title/Caption/etc.
Matthew referenced one of my posts, to give credit where credit is due lately I've been inspired by Cole Nussbaumer's work on using annotations, here's a sample post from her blog: storytelling with data: logic in order.
Does that answer your question?
Thanks Matthew and Jonathan. Those ideas might work just fine and I think there are no better options at this point. I'll try those methods you mentioned Jonathan.