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

Blanks appearing in visuals

Hi, I would like to check why there are blanks that appear randomly in our visuals. I have already made the necessary checks to my underlying data to ensure there are no blanks and that they are all correct, but sometimes, my visuals will have blanks appearing after restarting Power BI (although a quick fix if you use bookmarks is to just click on the bookmarked page in the bookmark pane).  

I know how to remove the blanks through the use of the filters, but I just would like to know if there are any specific reasons for it happening or is it just a bug? 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Blanks appearing in visuals

Hi @AUYS93,

 

Is there any relationships you created to other tables and with unmatched records?

 

If this is a case, when you use 'many' side table columns with 'one' side columns at same time, power bi will display 'blank' to summarize and replace unmatched records.

Slicer showing Blank as a value when data does not have any blank values

 

Regards.

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
3 REPLIES 3
Community Support Team
Community Support Team

Re: Blanks appearing in visuals

Hi @AUYS93,

 

Is there any relationships you created to other tables and with unmatched records?

 

If this is a case, when you use 'many' side table columns with 'one' side columns at same time, power bi will display 'blank' to summarize and replace unmatched records.

Slicer showing Blank as a value when data does not have any blank values

 

Regards.

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
AUYS93 Frequent Visitor
Frequent Visitor

Re: Blanks appearing in visuals

Hi Xiaoxin Sheng,

 

Oh yes, my data does have some unmatched records. Thank you for clarifying.

 

AUYS93

dgreen Regular Visitor
Regular Visitor

Re: Blanks appearing in visuals

Hi, I'm having a similar issue but I expect the blanks for one field where there is no match. The issue is it is taking an amount field I have, which shows values prior to me adding the new field, and makes those blanks as well. So I have an ID and amount field and all have values. I add a new field from another table that has one match. Now I only get information in the amount field where there is that match. Any idea why this happens?

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 288 members 2,957 guests
Please welcome our newest community members: