Forum Discussion
Parameters - filter issue. Bridge table?
Hi all, I have quite big table with work orders (approx 40k rows). A snipped would look like that: UID DateTime Status Shift Unit Machine WO001 01/01/2024 13:55 In progress A Unit...
Hi RafalDA
The reason it doesn't work with the seperate fields:
Unit has 4 values
Status has 4 values
PBI has no idea how these 2 related, can a unit have all 4 status or just 2.
If you instead create your parameter table using the Main tables fields then it knows how they connect.
Here for example Status Shift has only one Shift B so it can display.