Forum Discussion
Undefined
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)
8 Replies
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-Forum/ba-p/963216
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/1447523https://drive.google.com/file/d/1ZRU9Ro45H9zcqWwoDVhjbQKtk6oVLtAz/view?usp=sharing
Please find the above pbix file link
please check the link, it requires access.
Hi lbendlin please check the below link
https://drive.google.com/file/d/1ZRU9Ro45H9zcqWwoDVhjbQKtk6oVLtAz/view?usp=sharing
