Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Fernklyn
Frequent Visitor

Is there a way to fix blank data in visualization?

Hello, 

Is there a way to fix blank data in visualization? and Do you know where the blank value came from? What are the causes of blank value?
😀

Fernklyn_0-1673603025625.png

 

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @Fernklyn ,

 

it's difficult to tell why it is blank if you don't share any information 😉

But you can hide them with the filter pane or the visual:

selimovd_0-1673606526969.png

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

View solution in original post

4 REPLIES 4
johnt75
Super User
Super User

A blank row is automatically inserted into a table on the one side of a one-to-many relationship if there are values in the table on the many side which do not exist in the table on the one side. You might be able to identify which values are missing from the one side by creating a table visual with the column which is used in the relationship on the many side and then add the column from the one side as a filter to only show blanks. 

amitchandak
Super User
Super User

@Fernklyn There can two reasons for blank.

 

The Join between dim and fact, there blank(null) value in the join column on fact side

 

or dimension table is a missing value.

 

If possible resolve those. Else use visual level filter for axis column and remove blank

selimovd
Super User
Super User

Hey @Fernklyn ,

 

it's difficult to tell why it is blank if you don't share any information 😉

But you can hide them with the filter pane or the visual:

selimovd_0-1673606526969.png

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

Thank you so much. This solution is work for me. 😃

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors