cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

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

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

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

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

View solution in original post

Highlighted
Helper I
Helper I

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

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?

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors