Please see sheet 3 in attached workbook
I have created a parameter to use as filter
and a calculated field to work out what should be displayed
Hope this helps you.
Let me know if does anything different to what you required
Year Calculation.twbx 21.7 KB
Here is one possible solution:
The dashboard consists of both the yearly and monthly sheets but one of them is hidden based on the following calculation:
Year Calculation.twbx 14.6 KB
Many thanks for your response. I really appreciate. Your approach was very helpful. however we can't fix the year as a parameter that has to be dynamic.
The Reply from Lucasz actually resolves the issue completely. Still I shall keep your approach in mind, may be in some other case I may use this logic.
That was extremely helpful. Many Thanks for helping me with this.