Forum Discussion

jasonyeung87's avatar
jasonyeung87
Helper 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 reco...
  • lbendlin's avatar
    1 year ago

    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.