Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

Hello Friends,

 

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

 

Dataset 1

 CountryAB

C

US1sddd
US2dmdfmfmmnfnmf

 

Dataset 2

 CountryAB

C

CA1sddd
CA2dmdfmfmmnfnmf

 

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

Need Help

5 Replies

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      I'm getting the above error

       

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      v-yadongf-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      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.