where to verify why my data is displaying (blank) values?

[kimhyunchae91]

Hi PBI Community,

I have an issue where data is showing up as (blank) but when i check the query editor, none of the values under the column is (blank)... 

Where should i be verifying to figure out why these datas are being manipulated to (blank)? 

Topic table & Speaker Status contains these blank values i am unaware of...

I verified the "model" tab to see if this specific table[column] has any (blank) values and it does not.

Any tips or troubleshooting ideas would be great!

Please let me know if anyone needs additional information...

Thank you!

[edhans · Accepted solution]

DAX will create a blank record if you have data in a many side of a relationship if a record for it doesn't exist on the one side of the relationship. So if you have sales data for Ford, Chevy, VW, and BMW in your sales data, but your "Manufacturer" table only has Ford, Chevy, and VW, DAX will create the blank for the BMW data. You can prevent this in measures using DISTINCT() vs VALUES() for example, but that won't help with slicers.

You'll need to filter the data out in Power Query before it gets loaded. So either add the BMW record to your manufacturer table, or remove BMW sales data from the sales data before it loads into DAX.

You can find this out in Power Query by merging (in my example) the manufacturer table to the sales table, and tell it to only show records in the sales tble that do not exist in the manufacturer table - a Right-Anti join.

[tarunsingla]

It could be a result of the relationships between tables. A table in itself may not have any blank values but if that table is used in relationships, it may cause blanks.

Please share the pbix file for more inputs.

Regards,

Tarun