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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.