Quadrant Chart - Implementation of Dynamic X Axis and Y Axis on a Scatter Plot Chart

[Anonymous]

We want to have dynamic X Axis and Y Axis on scatter plot which is based on the below conditions :

For categorizing the turnover as high/ low, the axis point will be defined as follows:
Basis the filter selection, turnover values for all the selected cells need to be arranged in descending order and cumulative turnover should be calculated. Now, the cells for which cumulative turnover is less than 80% of the total turnover of the selection, will be classified as High Turnover cells and the rest will be classified as Low Turnover cells.

Origin point for vertical axis ( Y Axis ) will be set at the average of the turnover of following cells:

Cell with minimum turnover value out of all the High Turnover cells

Cell with maximum turnover value out of all the Low Turnover cells

Origin point for Horizontal axis ( X Axis ) will be the average of Gross Margin.

Basically the below graph needs to be implemented in Power BI using Power BI.

On a Scatter plot , in the Analytics section I have used two measures to make Dynamic X Axis and Y Aaxis line based on below 2 measures  in the Constant line part.

Taken the Average of  Gross Margin for X axis based on filter selection and it is working fine.

But for the Dynamic Turnover Y Axis we have to take average of the Maximum of Low Turnover and Minimum of High Turnover and use that in the dynamic Y Axis , but after plotting the Y Axis we are facing latency issues and the Visual is not getting loaded .

This maybe due to the MINX and MAXX function which we are creating in our measure calculation( around 5M rows of data)

Lt test 2 Max = var a=IF('GCF vw_FactGeographycategoryfocus'[CumulativeSum_CountryCategory_New]>'GCF vw_FactGeographycategoryfocus'[80% Turnover_CountryCategory_New] && 'GCF vw_FactGeographycategoryfocus'[Lt test rank]=MINX('GCF vw_FactGeographycategoryfocus','GCF vw_FactGeographycategoryfocus'[Lt test rank]),

    'GCF vw_FactGeographycategoryfocus'[Total Turnover_New])

return a

How can we make this Y Axis Dynamic in the Scatter plot based on the filter selection.

Can anyone suggest any better approach for this implementation of Dynamic x and y axis in a Scatter plot to make it look like a Quadrent Chart.

[lbendlin]

See if this helps

How to Build a Native Quadrant Chart in Power BI - BI Elite