Forum Discussion
one page filter for two different dates
I have 2 visualisations on the same page. these visualisations are based on 2 different tables / each visualisation is based on its own, specific table. both visualisations contain a date field/co...
For 1st problem, I unselected the 'hierarchy date'-option by selecting the 'date'-option.
still, my table contains values / records for every day.
I want the user to only see a few years and corresponding quarters and months in the filter.
not every day / not all the days in the month....
Create this measure:
SlicerFilter = INT ( NOT ISEMPTY ( 'Table Name' ) )
and drag it to the filter pane and give condition as 1
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!