Forum Discussion

athena_Opp's avatar
athena_Opp
Regular Visitor
4 years ago

Drill Though for Overlapping data points scatter plot

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. 
    CategoryTotal Policy Impact ScoreTotal Policy Feasibility Score 
    Title 1812
    Title 2817
    Title 3826
    Title 4818
    Title 5821
    Title 6821
    Title 7820
    Title 8824
    Title 9817
    Title 10816
Need Help

2 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support
    4 years ago

    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's avatar
      athena_Opp
      Regular Visitor
      4 years ago

      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