Urgent Help

[Chandramouli_BI]

Created scatter plot & enabled 25th,50th,75th & 100th percentile lines in PowerBI. Now the scatter plot is divided into 16 grids. Now I created calculated column based on the grid values. (Ex: If a value falls below x axis 25th percentile value & y-axis 25th percentile value I assigned to grid 1 & so on upto 16 grids). Now I used grid column as a slicer. In my dashboard month slicer is also there. The problem is that if month slicer is not used. The grid is working perfectly but when I use month slicer the grid is not working properly. Percentile line values & scatter plot are working fine but grid is not showing correct values & when I click on particular month, in the grid slicer some values are missing(Ex:grid1, grid2,grid3,grid4 are not showing, remaining grids showing but incorrect values)

[123abc]

Here are some steps you can take to troubleshoot and potentially resolve the issue:

1. Check the Data Model: Ensure that your data model is set up correctly, and that the relationships between the different tables are accurately defined.

2. Slicer Interaction: Check the interactions between the slicers. Go to the "Format" section in Power BI and select "Edit Interactions." Make sure that the month slicer and the grid slicer are interacting correctly. You can adjust the interactions to ensure that they don't interfere with each other.

3. Filter Context: When you use a slicer to filter the data, it sets a filter context for the visualizations. It's possible that the filter context is affecting the calculation of the grid values. You may need to adjust your DAX formulas to consider the filter context when calculating the grid values.

4. DAX Measures: If you're using DAX to create calculated columns or measures for the grid values, review your DAX formulas. Make sure they are correctly handling the filtering based on the month slicer. You may need to use functions like ALL or ALLSELECTED to control the filter context.

5. Testing: To troubleshoot the issue, try creating a new report page where you only have the scatter plot and the grid slicer. Test if the grid slicer works as expected with the month slicer on this new page. If it works, it may indicate that there are conflicts or interactions on the original page causing the issue.

6. Version and Updates: Ensure that you are using the latest version of Power BI and that it's up to date. Sometimes, issues can be resolved by updating to the latest version.

7. Performance Optimization: Consider the performance of your report, especially if it's dealing with a large dataset. Performance issues can affect the behavior of slicers and visuals. You might need to optimize your data model and use features like aggregation or summary tables to speed up calculations.

8. Testing Different Visual Types: Consider testing different visualization types to see if the issue is specific to the scatter plot or if it persists with other types of visuals.

If you're still facing issues after checking these points, it might be helpful to share more specific details about your data model, DAX calculations, and slicer settings. Providing more information will make it easier to diagnose and provide a more precise solution to your problem.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.