Forum Discussion
Filter Selection Calendar, Fiscal or Date Range
Hello Experts,
I have a requirement to allow user to choose to filter the data by Fiscal, Calendar or Date Range. Currently, I got the Fiscal/Calendar filter working. I need help with the Date Range option. My report has two slicers.
Calendar/DateRange/Fiscal slicer bases on a derived table I created
Year slicer bases on my date table
my data model is
I created a measure to capture the trial count base on user selection of Calendar or Fiscal as follow
for the third option Date Range, i'm thinking if have to add another slicer base on the Date table using the calendar_date field.
I'm not sure how to incorporate the Date Range option into the existing measure. I'm trying to add another Variable
DateRange =
how do I reference the date range user picks in the calendar_date slicer to only count the trials within the date range?
how do I return this third option in the result?
Any help/suggestion is greatly appreciated.
Thank you in advance
2 Replies
- lbendlin
Super User
I have a requirement to allow user to choose to filter the data by Fiscal, Calendar or Date Range.Is this something your users asked for? Have you tried showing them the Filter Pane?
@Ibendlin, thank you so much for your response. Yes this is my requirements. Users want to use the dashboard with the filtering as I demonstated. I got it to some what working. However, the year slicer seems to affect the result. For example, if i pick year 2021, as long as my date range is 01/01/2021 - 12/31/2021 the result is correct. However, if I change the year, the date range slicer seem to get ingore and I got incorrect result. I even use removefilter(date[year]) and still not working. Any more suggestion would be greatly appreciated.
