1 Reply Latest reply on Mar 3, 2017 9:33 AM by Patrick A Van Der Hyde

    "Show missing values" but only for previous week (not for the last one)

    Alexis Piazza



      unfortunately I can't attach the workbook since it's from my work, but I'm uploading a screenshot just to clarify what I want and probably help you guys to solve my problem.


      The thing is: I have a Week filter (String, not Date) and I want to show only the last week chart. I made a function called "ShowLastWeek" that make all the other weeks with empty values. Then, if I uncheck "Show Missing Values", I can hide all the previous week (that's working well), but unfortunately it also hides the empty columns on my last week ("Calls", "Direct" and "Other").


      Is there a way not to hide the empty bars in my last week?


      Thank you!