Chart Titles that adjust to the drill down layer

[codyraptor]

I'm looking for a way to change messages based on different drill down levels in a bar chart.  My hierarchy is Trade, Manager, Representative, State, Market, Vendor.

This is my DAX formula so far...

Selected = VAR Selected = FIRSTNONBLANK(Trade[Contrel Trade],TRUE)                                                                                                               VAR selected_trade = FIRSTNONBLANK(Trade[Contrel Trade],TRUE)  

                  VAR selected_Manager_Name = FIRSTNONBLANK('Contrel Manager'[MANAGER_NAME],TRUE)  

                  VAR topvolumebyMarket =MAXX(SUMMARIZECOLUMNS(Dispatch[MANAGER_NAME],Dispatch[MARKET],

"MaxDispVolume",Dispatch[Disp Count]),[MaxDispVolume])          

                RETURN

                     IF(HASONEVALUE('Contrel Manager'[MANAGER_NAME]), selected_Manager_Name & "'s largest dispatch volume is in Market " & FORMAT(topvolumebyMarket,"###,0"),"PICK SOMETHING!!!")

The return statement works if I go to that layer in the chart, but I lose it if I use the 'Drill Down' feature.  I can't seem to get any of the other layers to respond either.  ANy help is greatly appreciated!!!

[MattAllington]

Drill down does not change filter context, so your measures won't update. I thought the standard headings auto updated during drill through

[codyraptor]

I'm not using standard headings...I'm using a card to call out specific information based on the drill down.  Another words...it would be a dynamic card to say something based on selected State...the next level..I might change the message based on selected Manager...etc...

[MattAllington]

And as I said, drill down does not change filter context, so this approach is not going to work.  But if you look at the standard headings I think you will find that they do work.