Forum Discussion
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
- lbendlin
Super User
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
Helper V