I have a dataset for products and their corresponding sales at a year level. Some products are present in both the years (previous and current). Some are there only in current year and vice versa.
When i display these products and their sales, for the products which are not there in current year, sales column has missing values. When i sort the data by descending order of sales, the products with no sales in current year ( missing value rows) come at the last. Hence my bottom products come as these. But i want the products with actual low sales to be shown as the last products. Is there a way by which i can replace these missing values with 0s?
I am attaching a sample dashboard for reference.
Referring to the dashboard - Dairy Milk should come in the end.