Forum Discussion
Selection Panes In Scatter Chart
Hi guys, I have my custoemrs split base don 2 factors, sales rank and margin rank. I was wondering however if it is possible to select/drilldown based on specific percentiles which I plan to include in y visual. For example, above I have the sales ranks segmented by a percentile line, is it possible to create a measure to select that speciifc pane to understand what customers are within that percentile grouping based on their respective sales rank?
3 Replies
cdawidow - Maybe? I'm not sure I understand the requirement. It sounds like a measure aggregation question to me but not sure, This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.In theory, you could do your SUMMARIZE with your measure and then FILTER that based upon some threshold. Again, I can't be certain what you are going for.
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.- You don't have to clutter this visual with another functionality. You can put another visual on the canvas that will store the percentiles (or whatever you want) and you could create a measure that will respond to selections in such a visual (slicer?). Then you can use this measure in the Filter pane of the above visual so that it'll only show you the points you're interested in. The key is the measure: it'll return 1 for points which belong to the selected percentile and 0 for others. Should be easy.
- By the way... If you want to keep all the points but only highlight the ones that fall into a specific interval, you can create a measure that you'll use for conditional formatting of the points...
