Reply
jasonyeung87
Helper V
Helper V
Partially syndicated - Outbound

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.

jasonyeung87_0-1736891154553.png

 

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

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Syndicated - Outbound

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.

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Syndicated - Outbound

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.

Syndicated - Outbound

Hi @lbendlin 

Thanks for the info. 

Jason

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric Community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)