Hello Fareeza Khurshed,
You could create a text field to replace the use of [Indicator] on the Labels shelf that displays text when the value is null.
If Isnull([Indicator]) then "No Data Available" else "$"+STR(INT([Indicator])) end
As for the most recent year of data appearing by default, I don't have a way to do that off the top of my head. I'll keep exploring though.
Thanks Patrick, that works well