Multiple connections/datasets whch has same columns dynamic slection based on slicer selection

[Anonymous]

Hello Friends,

I am creating a dashboard by using direct query mode & the data has similar to the one below.

Dataset 1

Country	A	B	C
US	1	sd	dd
US	2	dmdfm	fmmnfnmf

Dataset 2

Country	A	B	C
CA	1	sd	dd
CA	2	dmdfm	fmmnfnmf

I am creating a dashboard that works for both datasets.

the moment i select us a visual or report will show from the dataset-1 & if I select CA a visual or report will show from the dataset-2.

I need help to do that.

Ay suggestions, please.

Thanks,

Naveen

[Anonymous]

Hello Yadong Fang,

Thanks for the help,

I have tried this earlier and it's working very slowly since appended query will take a long time to load since it's huge data.

The appended query will be again import mode, & i have to create Direct query mode only.

My assumption is can we do it by creating the measures?

Thanks,

Naveen

[v-yadongf-msft]

Hi @Anonymous ,

Please try following DAX:

Table = UNION('Dataset1','Dataset2')

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yadongf-msft]

Hi @Anonymous ,

Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.

Best regards,

Yadong Fang

[v-yadongf-msft]

Hi @Anonymous ,

Please append two tables in Power Query:

You will get a table like this:

Then you can implement dynamic selection based on slicer

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I'm getting the above error