How to create a new table base on a slider selection from 2 tables

[PamelaAG]

Hi all,

I would like to create a new table based on two other tableS with no conecction between them based on a slider selection.

For example, I have this two tables

Table 1
Task ID	Module	Result
1	A	0.1
2	B	0.2
3	C	0.3
4	D	0.4

Table 2
Method	Date	Measure
100	5/2/2020	10
200	5/3/2020	20
300	5/4/2020	30
301	5/5/2020	31

After this, the user will have to pick on the sliders the desired information

FILTERS
Task ID	1
Module	A
Result	0.1
Method	200
Date	5/3/2020
Measure	20

Is there a way to save these selections on a new table? So every time a user makes a selection, a new row will be inserted here? To have something like this 

Task ID	Module	Result	Method	Date	Measure
1	A	0.1	200	5/3/2020	20

[v-jayw-msft]

Hi @PamelaAG ,

It's not supported to create table based on selected value in slicer. If you tried then will find the table you created is empty.

Best Regards,

Jay

[amitchandak · Accepted solution]

@PamelaAG , You can not use slicer values in new table creation.

You can create an idea :https://ideas.powerbi.com/ideas/