Forum Discussion

AmyJPBI's avatar
AmyJPBI
Frequent Visitor
2 years ago
Solved

Field Parameters remove blank values

Hi,   I want my field parameters to only values that are populated and remove blanks. Is there a way i can override the parameter dax to remove them? As an example i am looking at my field paramete...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi AmyJPBI ,


    When two tables are linked through a regular relationship, the table on the one-side might contain the additional blank row in case the relationship is invalid. Thus, if the many-side of a regular relationship contains values that are not present in the table on the one-side, then a blank row is appended to the one-side table. The additional blank row is not added to the target of a limited relationship.
    Regular and limited relationships in Power BI - SQLBI




    1. Consider the repair relationship: the values of multiple ends are found in one end and are not null.
    2. Or add a visual filter to the table visual.



    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum