Undefined

[Anonymous]

Created scatter plot & enabled 25th,50th,75th & 100th powerBI percentile lines(In analytics pane) 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)

https://drive.google.com/file/d/1ZRU9Ro45H9zcqWwoDVhjbQKtk6oVLtAz/view?usp=sharing

SummaryTableX & SummaryTableY are calculated from agg_route_trip table. SummaryTableX contains service wise EPK & SummaryTableY contains service wise count of distinct date_key(service wise no of operated days)

[Anonymous]

https://drive.google.com/file/d/1ZRU9Ro45H9zcqWwoDVhjbQKtk6oVLtAz/view?usp=sharing

Please find the above pbix file link

[lbendlin]

please check the link, it requires access.

[Anonymous]

Hi @lbendlin please check the below link

https://drive.google.com/file/d/1ZRU9Ro45H9zcqWwoDVhjbQKtk6oVLtAz/view?usp=sharing

[lbendlin]

Now I created calculated column based on the grid values. 

Calculated columns will not be impacted by user interaction with your visuals.

Using a regular filter seems to work ok?

[Anonymous]

This is working but the requirement is (The above scatter plot is showing july month data) if I select grid 1 in the grid slicer then only only those values should come for July month (i.e. values less than or equal to 15 & less than or equal to 33.63 from the above scatter plot) . Similarly for all 16 grids.

After selecting July month the scatter plot is again divided into 16 grids based on percentile lines. We have a Grid slicer. Now if we click on grid 1 then grid1 values should come similarly for other grids also. This is where I am not able to find the answer. Please help me with this. 

On the entire data it is working but after selecting month & then selecting grids..Not getting the exact output. Please help me with this

[lbendlin]

Once you select a grid then the percentiles  apply to that specific grid.

if we click on grid 1 then grid1 values should come similarly for other grids also

Not really?

If you want to zoom in on a particular grid you can use the zoom sliders.

[Anonymous]

Yes if I click on particular grid then the percentile lines change according to that particular grid. From the scatter plot above if I click on Grid 1 then the values less than or equal to 15 & less than or equal to 33.63 should come. Approximately 13 values are there in grid 1. Now in that grid 1 again percentile lines are divided into 16 grids but the values <= 15 & 33.63. What I meant is again these 13 values are into these 16 grids based on the percentile values. 

I hope I am clear with my requirement

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...