Drill-down chart problem showing what data I came from
Hi,
This sounds like an easy one, but can't find any easy way of doing it!
I have a simple bar chart showing multiple columns for each person. I can then drill-down into that person to see month-on-month data across financial years. This is all working correctly, but when I have drilled-down I lose the text of which person I am looking at. So when I'm in the drilled-down view of months, you can't see which person you're looking at.
I could put this in the title of the chart or something similar, but I only want it to show when the chart is drilled-down to the second level.
If you're just looking for a way to show what you've got selected then a Current Selections box will show this.
You're probably looking for something that displays in the chart itself though. If you want it in the title then something like this might work as a title which will only show when a single Person is selected:
=if (count(distinct Person)=1, 'Financial Data for '&only(Person), 'Financial Data')
Of you could do something similar with Text in Chart. If you put =only(Person) as Text in Chart that should only display when a single Person is selected.
If you're just looking for a way to show what you've got selected then a Current Selections box will show this.
You're probably looking for something that displays in the chart itself though. If you want it in the title then something like this might work as a title which will only show when a single Person is selected:
=if (count(distinct Person)=1, 'Financial Data for '&only(Person), 'Financial Data')
Of you could do something similar with Text in Chart. If you put =only(Person) as Text in Chart that should only display when a single Person is selected.
