It sounds like you're encountering an issue with your Power BI setup where selecting two robots simultaneously results in blank values in your matrix visual. Here are a few troubleshooting steps you can try to resolve the issue:
Check Data Model Relationships: Ensure that your data model relationships are correctly set up between the Robot Name column and the Parts column. Verify that the relationships are one-to-many or many-to-one as needed.
Check Filter Context Interaction: Make sure that the filters applied by the slicers are interacting with the matrix visual as expected. Sometimes, conflicting filter contexts can result in unexpected behavior. You might need to adjust the interactions between slicers and visuals.
Verify Slicer Configuration: Double-check the configuration of your slicers to ensure they are set up correctly. Ensure that both slicers are filtering the Robot Name column independently, and they are not conflicting with each other.
Test with Different Visuals: Try using different types of visuals to see if the issue persists across different visualizations. This can help isolate whether the problem is specific to the matrix visual or if it's related to the data model or slicer configuration.
Review DAX Measures: If you're using DAX measures in your matrix visual, review them to ensure they are correctly calculating the values based on the selected filters. There might be a DAX measure causing unexpected behavior when both slicers are applied simultaneously.
Consider Combining Slicers: Instead of having two separate slicers for each robot, consider combining them into a single slicer that allows users to select multiple robots simultaneously. This can simplify your report and potentially avoid conflicts between slicers.
Check for Power BI Updates: Make sure you are using the latest version of Power BI Desktop, as updates often include bug fixes and improvements that might address issues like the one you're experiencing.
By carefully reviewing these aspects of your Power BI report, you should be able to identify and resolve the issue with the blank values in your matrix visual when selecting two robots simultaneously. If the problem persists, providing more detailed information about your data model, slicer configurations, and visuals can help further diagnose the issue.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
