hi @antonbcristina Another question, how come that the category “Department” only contains “Sales while I filtered “Sales” and “Purchasing”? See pictures.   I am sorry for all the questions, I would like to understand it better.   Thank in advance.         ... View more

Another question which is a fellowing about this topic. I use the data filter sets. I have noticed that I need to prepare everytime. How can I prepare it once before I loaded in a new report/canvas? Is there option for this?   Thanks in advance.     ... View more

Hi @antonbcristina, your solution did work, thank you for your effort and help 🙂    ... View more

Hi @antonbcristina    Thank you for your fast reply and your help. I have used the filter.  When I am not check the box "include missing value" nothing is going to change (see picture 1). I expect then then the missing value will be gone.  Eventually I have to adjust the line of value's to get the missing value gone (see picture 2). Does this work like this?   Second question, the course did not mention anything about filter the data. I assume the missing value is filter out in preparing the data and load it in the canvas. Is this true and when yes, how can I filter the missing data before loading in the canvas?   Thanks in advance.   I am looking forward hearing from you.        ... View more