Forum Discussion
Dyanmically changing the title based on the drill down
You create a measure that returns text. The measure detects the state of various filters and concatenates various peices of text accordingly. Will Thompson shows how at about 28 minute mark of this youtube video.
https://www.youtube.com/watch?v=d2bZpNZ6uIA
Hey Brian_M, the video only shows once a filter has been clicked and applied across the page. What Anonymous appears to be referring to is when you drill down to another level of the hierarchy. So in this case, the hierarchy would be Year -> Quarter and it would be in one visualization. I tried tinkering with this and I can't seem to get the value out of the filter, I'll see what else I can find out.
Ah, I missed that!
I wonder whether you could write DAX to detect the drill down, perhaps you could detect the Year context disappears altogether?
Yeah I'm not sure if that's possible. What's interesting is if you enable drill down and click on a visual, under "visual filter" it says that it's been applied. However, clicking on a visual without drill down enabled doesn't add a "filter" to any of the filter levels on the right side pane (visual, page or report).
If clicking on a part of visual changes everything else on a page, you would think that's a "page" filter, albeit a temporary one as once you click out of the visual, the filter should be removed.
Just a couple of other thoughts is all...
Sorry, forgot to mention. You turn off the exisitng title and place a text measure in a single item card above the chart to act as the dynamically generated title.
