@LilYawney
Based on the information you've provided and the image you sent, there are a few potential reasons why your slicer might be showing a blank "SW/WW/C" entry even though there's only one expense with that SBU:
1. Blank value in underlying data:
- Check the raw data table associated with your slicers. Ensure there are no blank or null values in the "SBU" column, especially for rows corresponding to the "SW/WW/C" entry. Even a single blank value can cause the slicer to display a blank option.
2. Slicer relationships:
- If you have multiple slicers connected to the "SBU" dimension table, there might be an issue with the relationships between them.
- Go to the Manage Relationships section in the Power BI Desktop ribbon.
- Review the relationships between your slicers and the "SBU" table.
- Ensure bidirectional filtering is enabled for the relevant relationships. This allows filters from one slicer to correctly propagate to other connected slicers.
3. Slicer formatting:
- While you mentioned the slicer settings are set to hide options without data, double-check the formatting options specifically for the "SBU" slicer.
- In the Formatting pane of the slicer properties, look for options related to blank values.
- Ensure they are not set to display blank values even when hidden.
Troubleshooting steps:
- Examine the raw data: Check for blank values in the "SBU" column of the underlying data table.
- Review slicer relationships: Verify that relationships between slicers and the "SBU" table are set up correctly, with bidirectional filtering enabled.
- Inspect slicer formatting: Double-check the formatting options for the "SBU" slicer, ensuring blank values are not displayed even when hidden.
By following these steps, you should be able to identify the cause of the blank entry in your slicer and take corrective action.
