Loading a table from another table based on the date value selected from a date slicer

[Surya1]

I have two tables.Table 1 & Table 2

Table 1 is static it is kept as a reference table.

Table 2 is getting refreshed daily.

I want to create a table 3 by merging Table 1 & Table 2 ,where this table 3 holds al the data modelling columns.

My query is how can i merge table 1 table 2 based on the date selected in the date slicer of the report ?I dont want to merge the entire records and create the modeling.I want to merge the records which comes under the date which a user selects in a report slicer.

Note:I want to have all the columns from table 1 n Table 2 in Table 3 with the filtered rows.In Table 2 there is a date column available.

[v-yuta-msft · Accepted solution]

Hi Surya1,

In power bi, when the data source changes->data model or data in data model level will be changed->data visual in report level will be changed. But the process can't be implemented inversely. 

In your senario, you want to use a slicer in report level to filter row records in data model level, however power bi doesn't allow to do that. As a workaround, you can merge all records in two tables, after applied, you can create a table visual and a slicer on table3.

Then you can use the slicer to filter table3.

Regards,

Jimmy Tao

[Surya1]

Thank You Jimmy.

I was able to create a measure which holds the date value from the slicer.Cant we use this in a filter to load the table?