How to keep Filters active even after changing dimensions
Hope everyone is doing safe during this pandemic.
I'm trying to apply filters on time dimension on a standalone basis, but unable to do unless I bring in other dimension to columns. When I change the view I lose the time filter based on a line item in the same module - 'Current Year?'. Any reasons why Filters become inactive with change in dimensions?
How do we go about keeping filters active even after changing dimensions? hope there is a quick and easy way to deal with this than a long workaround.
Use a filter module which only contains time period as a dimension.
I suspect you are creating the time filter in the same module as the data to be filtered. This is not best practice as you will need to recreate the filter each time it is required.
By creating a single filter source only containing time it can be used in all modules that require it.
When applying this filter to any other module the view will remain filtered despite changes in the dimension.0
I created a new Module 'Time Filters' but still, I don't find that appearing in the filter view in the working module.0
The time periods need to be the same between the filter module and the target.
If the module to be filtered is in years then the filter module must also be years.
If your second module uses a different time period then you will need to create a time filter using this time period.
Are they the same?0
They are the same time dimensions - Model Calendar - Months.0
Thanks, @ChrisAHeathcote for the earlier response. We figured out the issue is driven by the Brought Forward selection. If we disable it then Time Filter module is visible. In the scenario I'm handling I need to use the Brought Forward feature.
How do we overcome this issue as we need to publish few saved views in a dashboard for user input?