Forum Discussion

ysapiyev's avatar
ysapiyev
Icon for Responsive Resident rankResponsive Resident
8 years ago
Solved

Bookmark with slicers

Hi everyone,   I have a report page with several slicers. And I'm using bookmark to clear slicers. However, Ihave a date filter, which is controlled by cutom filter, so it will display selected per...
Tips and Tricks
  • ysapiyev's avatar
    ysapiyev
    8 years ago

    Solved issue by applying bookmark to selected visuals, excluding date filter.

     

    Regards,

    Yerkhan

ysapiyev's avatar
ysapiyev
Icon for Responsive Resident rankResponsive Resident
8 years ago

MFelix

 

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's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

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 monthn

Maybe you can use something similar to adjust your values to get the last 3 months.

 

Regards,

MFelix