Forum Discussion
Field Parameters remove blank values
- Anonymous2 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 TeamIf 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
Do you know why you have blanks in that column in the first place? Can you eliminate them there?