Adding Custom options in Power BI Desktop filter

[jasonyeung87]

Hi,

I currently have a filter in my Power BI Desktop report which obtains the options from the table it is filtering.

At least 1 record in the table has one of the 5 listed. When a record is created in this table, the Project Status could be chosen from 7 different values. The other 2 doesn't appear because there are currently no records that have that value.

I was wondering how do I add the 2 remaining values to this filter, even if there are no records in the table that has this value? Is there a way to add custom values in the filter?

Jason

[lbendlin · Accepted solution]

Use a reference table that has all expected values.

Feed the slicer from the reference table

Join the reference table to the data model so it controls the fact table.

[jasonyeung87]

Hi @lbendlin 

Thanks for the info. 

Jason