There was at a time, an attribute for the x-axis or value in a table to ‘Show rows with no data’. Not sure what Microsoft did with this option, but it is no longer available for some reason….