Forum Discussion
Responsive ResidentBookmark with slicers
Solved issue by applying bookmark to selected visuals, excluding date filter.
Regards,
Yerkhan
Responsive Resident
Thanks. Is there any way to update bookmark as scheduled process or something else?
Currently, date slicers shows data for 3 months rom yesterday. So, when I click on bookmark, it goes to state, when bookmark was created. So, is it possible to clear it some other way?
Regards,
Yerkhan
Super UserHi ysapiyev,
When you say that your bookmark show information from 3 months for yesterday is all your report filtered to that or is is just the values that are selected in the slicer and people then can go back?
If it's all the report on the report visuals if you choose the advance date filter to get previous 3 months, should work.
Regards,
MFelix
- ysapiyev
3 month is default value. There is custom date filter and regular. Regular is used to select date input, custom to select date periods. So, user can select period, for example year, and select specific date through regular filter.
So, when I use advanced filter, I can't go back then 3 months.
Regards,
Yerkhan
- MFelix
Hi ysapiyev,
I have a dahsboard, that need to have last month always showing however I compare with AOP and Forecast that goes all the way until december, and getting the current month value for actuals based on slicer was always giving me 0 because there were no actuals on the maximum date (december)
I use a change on my actuals measures to look something like this:
Current Year = VAR Selected_Min_Date = MIN ( Dim_date[Date] ) // Select Mininum date of calendar to get year VAR Select_Max_Month = MAX ( Dim_Date[Month] ) // Select Maximum date to check if it's until december RETURN IF([Actuals] = 0; BLANK();IF ( DISTINCTCOUNT ( Dim_Date[Month] ) = 12; CALCULATE ( [Actuals]; Dim_Date[Date] = DATE ( YEAR ( Selected_Min_Date ); IF(MONTH ( TODAY () ) = 1 ; 12 ; MONTH(TODAY()) - 1) ; 1 ) // choose the month before current month ); CALCULATE ( [Actuals] ; Dim_Date[Month] = Select_Max_Month) )) //otherwise give current monthnMaybe you can use something similar to adjust your values to get the last 3 months.
Regards,
MFelix