Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Urgent help: PowerBI

I Created scatter plot with 16 grids using percentile lines (25th, 50th, 75th & 100th). Month filter is not responding to the calculated column SelectGRID & Scatter plot. The requirement is month wise client wants to see each 16 grids data in the scatter plot. Lets say if client clicks on month july then scatter plot will show july month services with 16 grids & now client wants to check each grid wise services. This is where I am facing the issue. Consider the second scatter plot. If july month is selected then in the selectgrid slicer some grids are missing but in the scatter plot all 16 grids are showing. On the entire data the selectGRID & Scatter plot is working properly

 

DAX used in this I have mentioned in the pbix file

Please go through these files for better understanding. Thanks

 

Sample File

https://docs.google.com/spreadsheets/d/17nN-7N8CmA_3rnTQTLj7MeXa00qymR-k/edit?usp=sharing&ouid=108100635835723086697&rtpof=true&sd=true 

 

PowerBI File Link

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

 

As the deadline for submission is approaching this weekend, I would greatly appreciate your assistance in resolving this issue.

1 Reply

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar

    Hi,

    I'm trying to undertand your problem and on the second scatter plot I've put the "Select_GRID" column as a legend and for July the scatter only shows values to some of grid and it's matching with values on the slicer:

    What am I missing here?