It seems like there might be a few reasons why your slicer is not working as expected in Power BI. Here are some steps you can take to troubleshoot and resolve the issue:
Check Relationships: Make sure that the relationship between the new table/column and the original table is correctly defined. In Power BI Desktop, go to the "Model" view, and verify that the relationship is established properly. Ensure that the relationship is based on the correct columns.
Check Data Type Compatibility: Ensure that the data types of the columns used in the relationship are compatible. The data types should match, or there should be an implicit conversion possible between them.
Check Slicer Values: Double-check the values in your slicer. Sometimes, there might be spaces or additional characters that are not immediately visible. Also, verify that the values in the slicer match the values in the combined column.
Check DAX Measures: If you have DAX measures that use the combined column, ensure that they are written correctly. Any errors in the DAX measures could result in blank visualizations when a slicer value is selected.
Check Filters on Visualizations: Inspect the filters applied to your visuals. It's possible that there are other filters on your visuals that conflict with the slicer selection, causing the visuals to show blank results.
Use DAX Calculated Columns Sparingly: While calculated columns can be useful, they can also impact performance. Consider using DAX measures instead of calculated columns, especially if you're dealing with large datasets.
Check for Errors: Look for any error messages in the Power BI Desktop. If there's an error in your data model or DAX formulas, Power BI will often provide helpful error messages.
Test with Simpler Examples: To narrow down the issue, try creating a simpler version of your report with just the necessary components. See if the slicer works in that scenario. If it does, gradually add elements to identify where the issue arises.
Update Power BI Desktop: Ensure that you are using the latest version of Power BI Desktop. Updates may include bug fixes and improvements that could resolve the issue you're facing.
By systematically going through these steps, you should be able to identify and resolve the issue with your slicer in Power BI. If the problem persists, consider reaching out to the Power BI community forums or support for more targeted assistance.
