Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |