Is there a way to fix blank data in visualization?

[Fernklyn]

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?
😀

[johnt75]

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]

@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 · Accepted solution]

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:

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

[Fernklyn]

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