I would recommend creating a separate sheet for each of the labels and then placing it appropriately on your dashboard since I do not know of a way to dynamically change a label.
I want to show something like below
ROY( Oct - Dec)
YTD ( Jan - Sep)
Please let me know if this can be possible?
This is very possible. Create a sheet called ROY Label. I assume you are using a parameters to set the date range, or maybe filters. I would create a calculated field called Label ROY. 'ROY(' + [Start Month] + ' - '+ [End Month] +')' Place this calculated field on Label and then format as you would like. Set this to fit Entire View and float it over the column on your dashboard.
I would show you pictures or upload an example, but security makes that impossible on my current assignment.