Scatter Plot

[Saiprasannakuma]

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.

[v-kkf-msft · Accepted solution]

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]

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]

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]

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.