I have a big problem. I exactly need to solve this problem.
I have a date dimension table as below. It different from standart because i have one fact table and it has both monthly and weekly values. It was joined on ID column. This part is not important. I just want to inform my case.
Our customer wants the filter which named as "Text" dynamically changes for current date. For example in the next month When they open the dashboard from web, they want to see May value to be selected on the filter by itself. That's the first thing. If it is possible then they want one more think.
When 'weekly' is selecting on dimension filter then on the text filter current week should be come with selected.