Forum Discussion
Column Header disapearing when filtering
Hi, I have a trouble. When I filter on Oscar, where there is no actuals numbers, the actuals column to the right disapears. How should I do to avoid ...
try this, click arrow next to product in value and choose "show data with no value", see if that works.
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHi Anonymous
An easy way to do this is just to add rows to your table with value of 0 for Oscar and Actuals. That guarantees you will get a result. The challenge with meaures is they won't fire for that cell if there is no underlying data.