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 appear without losing the design intention or page contribution of the visual. For many visuals, I'm trying to show the extremes or values which are away from the herd or the main group. A away to do this is with standard deviation or using two percentile bands at either end (10%, 90%).

 

Does anybody have an idea of how to create a measure or something I could use in the Visual filter box to filter what appears on that visual for that measure's values.

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

5 Replies

  • 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