Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 that? I want it to show blank or a 0.

 

It is the same with Produkt. I always want it to show even if there is no number.

 

Thanks.

 

Best Regards

Hansi

Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    try this, click arrow next to product in value and choose "show data with no value", see if that works.

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    try this, click arrow next to product in value and choose "show data with no value", see if that works.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi,

       

      Perfect, now it works :)

       

      Thanks.

       

      /Hansi

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        8 years ago

        Anonymous what not worked? not sure what you tried from the two solutions.

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi 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.