Forum Discussion
Table Created with Field Parameters missing rows
I created a field parameter called Table Columns with 40 columns from 3 different tables (STIP or CHIP, MFB Dates, etc.). I used these to create a table visual. I then added a slicer to the page for the Project Number from the STIP or CHIP table. When I search for a Project Number that I know is there it doesn't pull it up in the table. As if it isn't in the dataset. I am just trying to figure out why this is happening.
Hi ACraig08 - In field Parameters allow mixing columns from different tables, but if some tables are disconnected, Power BI creates combinations that may return blank rows or unexpected filtering.
as you mentioned field parameter contains table columns from all 3 tables, the slicer on Project Number (from STIP/CHIP table) only filters correctly if relationships and filter propagation are working properly across all involved tables.
Use report readers to change visuals - Power BI | Microsoft Learn
Hope the above details helps.
2 Replies
Hi ACraig08 - In field Parameters allow mixing columns from different tables, but if some tables are disconnected, Power BI creates combinations that may return blank rows or unexpected filtering.
as you mentioned field parameter contains table columns from all 3 tables, the slicer on Project Number (from STIP/CHIP table) only filters correctly if relationships and filter propagation are working properly across all involved tables.
Use report readers to change visuals - Power BI | Microsoft Learn
Hope the above details helps.
It was the way my tables were connected via the relationships. Thank you!
