Forum Discussion

Idkpowerbi's avatar
Idkpowerbi
Helper I
3 years ago

Sharing values between parameter tables

  EDIT: Sorry about the tables, I m posting from my phone so the tables look whacky after posting. The quality and production tables each have 3 columns, date, production/quality, production_plan/qu...
lbendlin's avatar
lbendlin
Super User
3 years ago

That's not how you normally define DATATABLE()  but hey, it works, sort of.

 

Since both your new tables have a column "Value2" you could create another table with that column, call it a dimension, and control both parameter tables from it ...  Of course the names don't matter but the idea would be the same - have a dimension table control the field parameter tables.

Idkpowerbi's avatar
Idkpowerbi
Helper I
3 years ago

Can you show me how the new dimension table looks like? Also I am not sure how to control the parameter tables. Do I need to make relationships between the new table and parameter tables?

If this doesn't make sense 😞 please elaborate on your previous reply. Thanks for reading my question. 

  • Idkpowerbi's avatar
    Idkpowerbi
    Helper I
    3 years ago

    Hey lbendlin a bump in case you missed my previous question

     

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      Not sure where you are going with this.  based on the attached data model, what is your next step?