Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Chandramouli_BI
Helper III
Helper III

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=10810... 

 

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 1
_AAndrade
Super User
Super User

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:

_AAndrade_0-1712054997934.png

What am I missing here?





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.