Forum Discussion

jasonyeung87's avatar
jasonyeung87
Icon for Helper V rankHelper V
1 year ago
Solved

Adding Custom options in Power BI Desktop filter

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

 

 

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

2 Replies

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