- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
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.
Subject | Author | Posted | |
---|---|---|---|
07-09-2024 05:38 AM | |||
08-14-2024 05:41 AM | |||
04-05-2024 08:42 AM | |||
08-14-2024 10:51 AM | |||
01-26-2024 05:47 AM |
User | Count |
---|---|
115 | |
76 | |
45 | |
44 | |
32 |
User | Count |
---|---|
172 | |
90 | |
66 | |
46 | |
45 |