How do a filter on the entire page

[nataliesmiy1357]

Hello!  I am wanting to create a filter on the entire page of the Top N datetime.

I am able to do this on each individual visual... but not the entire page.  

I want the page to show the latest date in the dataset when there are no other filters selected.

[Daniel29195 · Accepted solution]

@nataliesmiy1357 

there is are custom slicer called  preselected slicer . 

download the sample ( you will use it later on ) . 

open the sample  you that you ve downloaded. 

copy from the sample the table preselectedslicer to your model . 

now for the slicer you have 3 values to populate : 

in fields --> date

in pre selection --> a measure that we will create it later. 

dirty status -->  the column isdirtysclier1 ( from the table you copy paste it from the sample ) 

now simply create the following measure :  ( assuming you have a star schema )  that you will add it to the pre selection : 

m = 

var max_date = max(dimdate[date])

return 

switch (

true () ,

iscrossfiltered ( fact_table) , 

if ( selectedvalue(dimdate[date]) , max_date ,1 , 0  ) , 1 ) 

( dont forget to hide the visual)   

hope this helps .