Forum Discussion

Sebastian's avatar
Sebastian
Advocate III
10 years ago

table chart shows null row

Hi all,

 

i use the table chart. It shows the article number and the price. The first row in this chart is a row full of null values.

I can't find the reason why.

 

Does anyone have an idea why?

 

 

 

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    You could try going back to your query and try adding the step, "Remove blank rows". It is in the Reduce Rows section, Remove Rows | Remove Blank Rows. If that doesn't work, you could also try adding a "Remove Errors" step in the same area.

    • greggyb's avatar
      greggyb
      Resident Rockstar

      If your fact table (many side of the relationship) has any rows that do not exist in your dimension (one side of the relationship), there will be an implicit extra row added to your dimension that is made up of all Blank values.