Forum Discussion

Surya1's avatar
Surya1
Helper I
8 years ago
Solved

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...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

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's avatar
    Surya1
    Helper I
    8 years ago

    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?