How to remove the null option from control drop down

Q&A
, ,
5

Hi @achourey,

There are two possible options:

  1. If your Activity Type and Source have limited values that do not change; you could build your parameter as a static list of values, that match in content with your Fact table. This way you exclude Null from the list
  2. Alternatively, if you have dimension table for Activity Type and Source as well you could basically do a similar join with the factor table as you did with calendar table and use the columns from the dimension tables for the parameter.