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 data' constant to every row

 

I want to create a slicer that as changed data and problem data as two different option 

How do I create this from two different Table

Please help

Thanks,

Sonam

 

amitchandak parry2k lbendlin Greg_Deckler PaulDBrown 

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.

3 Replies

  • parry2k's avatar
    parry2k
    Super 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  

  • parry2k's avatar
    parry2k
    Super User
    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.