Forum Discussion

ACraig08's avatar
ACraig08
Helper III
3 months ago
Solved

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 ...
  • rajendraongole1's avatar
    3 months ago

    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.