Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

values not showing if value is null

I have a table with 4 columns that are data type %.  However, whenever I add these columns into my Table Visual if the value for that column is null - it doesn't show up.  (Stores that are highlighted in yellow are not showing up on the table on right.)    When I go to Power Query those specific stores have null values.  I tried to replace null with blank but I can't because it's of type %.

 

 

  • Hey jcastr02 ,
    have you already tried this option?
    right click on the dimension --> show items with no data

     

1 Reply

  • Hey jcastr02 ,
    have you already tried this option?
    right click on the dimension --> show items with no data