Modify slicers defaults

[Anonymous]

Hello!

I need to modify slicers defaults. Don't know if it's possible.

I have 2 tables:

Table1:

Table 2:

And I have the slicer for field "Closed date" of Table 2:

Slicer takes minimum and maximum date of column "Closed date" of Table 2.

I would like to replace these defaults with values of Table 1. Is it possible?

If required, I have uploded power bi file to Google Drive

Thank you!

[CNENFRNL · Accepted solution]

Hi, @Anonymous , you might want to try it this way,

1. create a calculated column in Table2;

Closed date in between =
MIN ( Table1[Start] ) <= [Closed date]
    && [Closed date] <= MAX ( Table1[End] )

2. add this calculated column Table2[Closed date in between] to filter pane against slicer viz and tick True;

Then you get a date slicer corresponding to Table1.

[sanalytics]

@Anonymous 

Just create a table with your desired min date and max date then make virtual relationship.. refer the below file.. try the below measure

New Ticket = CALCULATE(SUM(Table2[Ticket #]),TREATAS(VALUES('New Table'[Value]),Table2[Closed date]) )

Attaching your file on below link

https://dropfiles.org/M2Lq0RjZ

Hope it will help

Thanks

sanalytics

if it is your solution please accept it as solution and please like.

[Anonymous]

Hello @sanalytics ,

I need to "insert" default values to slicer based on Table 1.

Is it possible to modify slicers data?

Thank you!