Forum Discussion

Saiprasannakuma's avatar
Saiprasannakuma
New Member
4 years ago
Solved

Scatter Plot

Can we make four matrix visuals along the sides of four quadrants in scatter plot ? The Matrix visuals should have data restricted to that particular quadrant only.

I'm looking for a way to achieve it.

 

 

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Saiprasannakuma ,

     

    Please create these measures.

     

    Avg_Col_1 = 
CALCULATE ( AVERAGE ( 'Table'[Column1] ), ALLSELECTED ( 'Table' ) )
    Avg_Col_2 = 
CALCULATE ( AVERAGE ( 'Table'[Column2] ), ALLSELECTED ( 'Table' ) )
    quadrant = 
IF ( SUM ( 'Table'[Column1] ) >= [Avg_Col_1], 5 )
    + IF ( SUM ( 'Table'[Column2] ) >= [Avg_Col_2], 10 )

     

    Then add constant lines to the scatter plot with values of measure [Avg_Col_1] and measure [Avg_Col_2], respectively.

     

               

     

    Quadrant 1:


    Quadrant 2:

     

    Quadrant 3:

     

    Quadrant 4:

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

4 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Saiprasannakuma ,

     

    Please create these measures.

     

    Avg_Col_1 = 
CALCULATE ( AVERAGE ( 'Table'[Column1] ), ALLSELECTED ( 'Table' ) )
    Avg_Col_2 = 
CALCULATE ( AVERAGE ( 'Table'[Column2] ), ALLSELECTED ( 'Table' ) )
    quadrant = 
IF ( SUM ( 'Table'[Column1] ) >= [Avg_Col_1], 5 )
    + IF ( SUM ( 'Table'[Column2] ) >= [Avg_Col_2], 10 )

     

    Then add constant lines to the scatter plot with values of measure [Avg_Col_1] and measure [Avg_Col_2], respectively.

     

               

     

    Quadrant 1:


    Quadrant 2:

     

    Quadrant 3:

     

    Quadrant 4:

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • mahenkj2's avatar
    mahenkj2
    Solution Sage
    4 years ago

    Hi Saiprasannakuma ,

     

    Can you please post a rough sketch of what you would like to achieve? If possible, please add some more details on your goal.

    • Saiprasannakuma's avatar
      Saiprasannakuma
      New Member
      4 years ago

      Hi @mahenkj2 ,

      Below is what i would like to achieve in Power BI. 

       

      The Matrix visuals at each quadrant should have the data restricted to each quadrant. 
      For Example:
      The Quadrant1 is having bubbles less than avg of x-axis and y-axis. So the matrix beside the quadrant1 should have the data which follows the same rule i.e value less than avg of x-axis and y-axis

      • mahenkj2's avatar
        mahenkj2
        Solution Sage
        4 years ago

        Hi Saiprasannakuma ,

        Thanks for the details.

         

        What you want is definitely possible and it needs to be created while designing your report.

        Just create scatter plot in the centre, small multiples in scatter chart are available.

        In four sides of scatter plot create 4 metrix visual, and filter each one matrix with specific condition needed for that matrix, by setting filter pane for that visual.

        I hope you understand. Once I get access to my pc, create a sample for you.

         

        Hope it helps.