Selection of value in slicer affects how my DAX works.Want some selected values in slicer to remain

[Sri95]

All my KPIs should depend on the 3 date columns that are available. My cards and visuals are using similar measures. Depending on the date selection in the 'Date Type Basis' slicer, my value should change, my DAX is also written according to that (as seen in the screenshots). I want the date range slicer to change depending on the date selection as well. So, I created 3 bookmarks for the 3 dates, put shapes over the dates, made respective date selections and put the respective date column in the date range slicer. The selection of 'Date Type Basis' is important for all my DAX calculations. There are other slicers below the date range slicer as well which are common for all dates. 
If I make some selections in the slicers below, and want them to remain even if I change the selection in 'Date Type Basis' table, what should I do?

If I uncheck Data for each bookmark, the other slicers values are remaining when I change the Date Type Basis slicer, but when I click the bookmark which is on the date is not changing and hence the values in KPI cards and visuals are also not changing as the DAX depends on the 'Date Type Basis' selection.

Is there a way to let the selection in the other slicers to remain when a bookmark is changed but, the Date Type basis selection changes as per the selected date.

Or is there a way where I can dynamically change the value of the date in slicer based on the 'Date Type Basis' slicer? 

[Anonymous · Accepted solution]

Hi @Sri95 ,

The bookmark saves the state of the visual when the bookmark was created, and when the user selects a bookmark, the visual returns to its default state.

You can create a relationship between the DateTypeBasis and three date columns, for example, in the calendar table, create a calculated column, and return "Date1" if the date is in the Date column in the RegdDate table. If the date is in the Date2 column, then "Date2" is returned.

DateTypBasis = SWITCH(TRUE(),'Calendar'[Date] IN ALL(RegdData[Date]),"Date1",'Calendar'[Date] IN ALL(RegdData[Date2]),"Date2","Date3")

Then put the Date column and DateTypeBasis column of the calendar table into the slicer.

When a user selects DateTypeBasis, the date range will be automatically filtered. When the user changes date range, the date range is saved even if the date category is changed.

———————————————————————————————————————————————————

If my answer solves the problem, please accept it as a solution. This will let it be seen by more people in need.

Best regards,

Mengmeng Li

[lbendlin]

 I want the date range slicer to change depending on the date selection as well.

That will not work if you had default values for that range slicer, or if the user interacted with the slicer. Selected values will continue to be visible even if they are no longer part of the new range.

[Sri95]

Okay, thank you! What do you think of the bookmarks? 
This - Is there a way to let the selection in the other slicers to remain when a bookmark is changed but, the Date Type basis selection changes as per the selected date.

[lbendlin]

Bookmarks need to exclude the data otherwise they make the problem worse