How to include null values or blank data in power bi table

Honestly, this functionality is so dumb!  Why would Microsoft program Power BI to exclude rows where a column has a null value???  I'm so, so baffled by this functionality.  

In my case, I have a SQL view (single table) that I pulled into a PBI dataset to record historical EEO snapshots for our HR department.  The table key is the snapshotID, which is never null.  The report should show all rows that match the Power BI filters but for some reason the decision was made to exclude entire rows where a single field was left null.  In my case as an example we have:

(SnapshotID, EmployeeID, EmployeeName, GenderIdentity, SnapshotDate)

(123456, 100731, Mickey Mouse, null, 2022-04-28)

Since Mickey Mouse didn't input a gender identity the result is that Power BI ignores the entire row of data.  I just don't get it, this is so, so weird and rediculous.  

Rant complete, thanks for listening.