Forum Discussion

Neha12's avatar
Neha12
Frequent Visitor
3 years ago
Solved

select values in a slicer from two different table

Hi,    I have two tables A and B Table A has one of the columns as Type and the value is 'changed data' constant to every row   Table B has one of the columns as Type and the value is 'Problem d...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    Neha12 well you don't need to load both the tables in the model, append Table B to table A and turn off table B not to load in the model, and this will not increase the size.

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

Neha12 maybe easier to append these two tables in the PQ and then everything should be super easy.

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

 

  • Neha12's avatar
    Neha12
    Frequent Visitor
    3 years ago

    But append would increase the data size, already both the table has got huge data size

    Is there any other option available 

     

    Thanks