Search code examples
powerbidaxrelationshippowerbi-desktop

Returning blank rows when a specific column is used

I seem to be having some issues with my data model as it is bringing back blank rows meaning that the relationship is invalid, so it is showing the rows that don't basically exist or cannot be matched.

With Branch Type Column

enter image description here

Without Branch Type Column

enter image description here

Data Model:

enter image description here

I know the main culprit has to be the data model but is there a way temporarily to actually not show those rows which dont have data?

Solution

  • I figured out how to solve my issue, I instead right clicked on the column and unticked show items with no data