Drill Though for Overlapping data points scatter plot

[athena_Opp]

Hi All, 

First off, thank you for having a look at my question. 

Here's the issue: 

I have a scatter plot with identical values (aboslutely no way around it). I've added a measure to increase the size of the bubble when there is more than one Category with identical values (see below). 

MY ASK: When the user drill through, I would like to be able list all of the Categories that have the same scores and allow them to select which one to drill through. (Right now, when you right click on a data point, it only allows you to drill through to one Category. 

Here is what I have done so far:

• Created a "bubble size" measure that allows me to show that, for example, there are three points with the same value: 

Bubble size = CALCULATE(COUNTROWS('Score Inquiry'),FILTER(ALL('Score Inquiry'), 'Score Inquiry'[Total Policy Feasibility Score]=SELECTEDVALUE('Score Inquiry'[Total Policy Feasibility Score])&&'Score Inquiry'[Total Policy Impact Score]=SELECTEDVALUE('Score Inquiry'[Total Policy Impact Score])))

• I know that I can jitter the dots. HOWEVER, the end users would be very confused if they saw two points with the same value slightly higher/lower than each other. (But if this is really my only option, I'll go for it. Suggestions on the DAX that won't ruin the actual score?). 
• I tried making a table but again, when I click on the data point in the scatter plot, it only displays one category and not all categories with the same scores.
• I know I can display the category names but unfortunately the titles of the categories are very long. 

  Category	Total Policy Impact Score	Total Policy Feasibility Score
  Title 1	8	12
  Title 2	8	17
  Title 3	8	26
  Title 4	8	18
  Title 5	8	21
  Title 6	8	21
  Title 7	8	20
  Title 8	8	24
  Title 9	8	17
  Title 10	8	16

[v-yingjl]

Hi @athena_Opp ,

As far as I know, currently drillthrough feature could not support this requirement in Power BI. With drillthrough in Power BI reports, you can create a page in your report that focuses on a specific entity. So it could be one to one drillthrough.

perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[athena_Opp]

Hi @v-yingjl , 

Thanks for getting back to me! I will definitely submit the idea. 

Do you have a suggestion of any other way I can make sure someone can drill through? Is jittering the data points my only option? (This means I would need to change the x,y values of the data points correct?) Is there way I can apply a filter that would allow me to see the dots?

Any suggestions are warmly welcomed 🤗

Athena