cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kimhyunchae91 Frequent Visitor
Frequent Visitor

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

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)... 

 

 

blank.PNGWhere 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!

1 ACCEPTED SOLUTION

Accepted Solutions
edhans Super Contributor
Super Contributor

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

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.

View solution in original post

2 REPLIES 2
tarunsingla Established Member
Established Member

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

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

edhans Super Contributor
Super Contributor

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

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.

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 169 members 1,857 guests
Please welcome our newest community members: