Forum Discussion

ElliotP's avatar
ElliotP
Icon for Post Prodigy rankPost Prodigy
9 years ago
Solved

Extreme Values, percentile or std deviation as filter

Morning,   I have a number of scatter charts which have too many bubbles to be easily interpretable or consumable, they could be a lot more. So I'm trying to reduce the number of bubbles which a...
Need Help
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi ElliotP,

     

    Actually, there is a right-angled triangle for every bubbles. So the length of "C" is the distance from every bubbles to the Origin. I call it Radius. The X-axis and Y-axis are numeric most of the time. So we can calculate the Radius and filter the bubbles by Radius. I just display a demo by setting it to "be greater than 30000". You can change it to any number.

     

    If you have some special scenario, please post a sample in TEXT mode. The PBIX file would be great.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi ElliotP,

 

I am sure that you know how to filter the visuals by filters and slicers. Then we can talk something else. There are two factors (X-axis and Y-axis). So to my opinion, it's hard to calculate the standard deviation. 

 

Maybe we can use the distance to the origin. In my example, I calculated the distance by this formula.

Radius =
SQRT (
    POWER ( SUM ( 'Sales'[Quantity] ), 2 )
        + POWER ( SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] ), 2 )
)

As you can see from the picture, I filtered the visual by Radius. There are less bubbles now.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

 

 

ElliotP's avatar
ElliotP
Icon for Post Prodigy rankPost Prodigy
9 years ago

v-jiascu-msftThat's incredible idea and the exact thing I was looking for.

 

What does Radius do exactly, in terms of setting it to be greater than 300k?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi ElliotP,

     

    Actually, there is a right-angled triangle for every bubbles. So the length of "C" is the distance from every bubbles to the Origin. I call it Radius. The X-axis and Y-axis are numeric most of the time. So we can calculate the Radius and filter the bubbles by Radius. I just display a demo by setting it to "be greater than 30000". You can change it to any number.

     

    If you have some special scenario, please post a sample in TEXT mode. The PBIX file would be great.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

    • ElliotP's avatar
      ElliotP
      Icon for Post Prodigy rankPost Prodigy
      9 years ago

      Ah ok, I thought I understood that part. From a practical standpoint, how does radius discern the datapoints it shows? Just datapoints which have a radius say greater x for example? 

       

      I just realised this, sorry for being a dill, you can use the radius to set the bounds for radius values; meaning; if radius is less than x but greater than y I can achieve the bounding idea.

       

      Thank you so much, that's an incredible idea.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi ElliotP,

         

        My pleasure. Just a tip, if you want to set a upper and a lower bounding, you can drag Radius into the "Visual level filter" again. Then there will be two Radius. 

         

        Best Regards!

        Dale