scatter plot
1 TopicUndefined
I created a scatter plot and enabled PowerBI percentile lines 25th,50th,75th,100th for both x & y axes (analytics pane option) . Now my scatter plot is divided into 16 grids. Now I created a calculated column based on the grid values & assigned each value in the scatter plot to grid. (Ex: If a value falls below x axis 25th percentile & y axis 25th percentile then I assigned this as GRID 1. similarly for other values to grid2,grid3....grid16. The grid slicer is working fine..if I select grid1 then only those prticular values are showing, similarly for other grids also. I have a month slicer in my report. When I want to check with particular month, the grid is not working properly. What I meant is initially if I click on grid 4 then only the values in grid 4 appeared. But affter selcting month (Lets say April month 30 days, the scatter plot is into 16 grids but now in the grid slicer some grids are missing even though in the scatter plot values are in all 16 grids. Also if I click on appered grids, the values are showing wrong.Percentile lines & scatter plot values are working fine but the grid is not working.745Views0likes3Comments