Quadrant chart

[SwapnilS]

Hi All,

I need some assistance with the quadrant chart representation.

I have the below data which I want to present in the Quadrant chart. On one axis I want priority and on other axis I want effort estimate. Bubbles should display the short description and its count in each quadrant.

I tried to use the custom visual , but it was not successful.

The problem is, the axis are not showing as the string values, it shows as count. 

[SwapnilS]

Hi, 

I am sharing the link of my one drive where the file is saved.

Pbix file 

[lbendlin]

The Hit list groups table is missing a suitable unique field to link back to the hit lists. It should not contain the EffortEstimate column. Maybe just a numeric version of the priority column?

You may want to re-watch this video Quadrant Chart by MAQ Software - Power BI Visual Introduction - YouTube

[Ashish_Mathur]

Hi,

There is no visual i see on the HIT List tab.

[SwapnilS]

Thanks Ashish,

I have done that yesterday

Priority - P1 = 1, P2 = 2, P3 = 3, P4 = 4, P5 = 5.

Effort Estimate = Small = 1, Medium = 2, Large = 3, Extra large = 4

The problem is that, the bubbles show a summarised value, I don't get a seperate bubble for each task, and I dont seem to be able to label it.

By the way, I am using reporting server version of power bi.

Regards,

Swapnil

[Ashish_Mathur]

Hi,

Could you share the link from where i can download your PBI file.

[Ashish_Mathur]

Hi,

A quadrant chart is a scatter chart with 4 compartments.  A scatter chart must have numerical fields in the X and Y axis.  So you will have to convert your 2 fields to numerical values.

[lbendlin]

What would be your desired definitions (and sort order) for the X and Y axes ?

[SwapnilS]

Hi There, Thank you looking into this.

On x- Axis I want priority and on Y axis I want Effort estimate.

Priority of 1 is critical and it keeps decreasing. So priority of 5 is extremly low. Priority values are P1 to P5.

Effore estimate scale is - small, medium, large and extra large.

Below is the switch statement I wrote to give the quadrant of the combination of priority and effort estimate. Please ignore the table name.

The combination should read like,

If priority is P1 and effort estimate is small, then it should fall in "Quick wins" quadrant.... and so on.

'HIT List'[Priority] = "1 - Critical" && 'HIT List'[EffortEstimate] = "Small", "Quick Wins",

'HIT List'[Priority] = "2 - High" && 'HIT List'[EffortEstimate] = "Small", "Quick Wins",

'HIT List'[Priority] = "3 - Moderate" && 'HIT List'[EffortEstimate] = "Small", "Quick Wins",

    'HIT List'[Priority] = "4 - Low" && 'HIT List'[EffortEstimate] = "Small", "Fill Ins",

    'HIT List'[Priority] = "5 - Planning" && 'HIT List'[EffortEstimate] = "Small", "Fill Ins",

    'HIT List'[Priority] = "1 - Critical" && 'HIT List'[EffortEstimate] = "Medium", "Quick Wins",

'HIT List'[Priority] = "2 - High" && 'HIT List'[EffortEstimate] = "Medium", "Quick Wins",

'HIT List'[Priority] = "3 - Moderate" && 'HIT List'[EffortEstimate] = "Medium", "Fill Ins",

    'HIT List'[Priority] = "4 - Low" && 'HIT List'[EffortEstimate] = "Medium", "Fill Ins",

    'HIT List'[Priority] = "5 - Planning" && 'HIT List'[EffortEstimate] = "Medium", "Hard Slogs",

'HIT List'[Priority] = "1 - Critical" && 'HIT List'[EffortEstimate] = "Large", "Major Projects",

'HIT List'[Priority] = "2 - High" && 'HIT List'[EffortEstimate] = "Large", "Major Projects",

'HIT List'[Priority] = "3 - Moderate" && 'HIT List'[EffortEstimate] = "Large", "Hard Slogs",

    'HIT List'[Priority] = "4 - Low" && 'HIT List'[EffortEstimate] = "Large", "Hard Slogs",

    'HIT List'[Priority] = "5 - Planning" && 'HIT List'[EffortEstimate] = "Large", "Hard Slogs",

'HIT List'[Priority] = "1 - Critical" && 'HIT List'[EffortEstimate] = "Extra Large", "Major Projects",

'HIT List'[Priority] = "2 - High" && 'HIT List'[EffortEstimate] = "Extra Large", "Major Projects",

'HIT List'[Priority] = "3 - Moderate" && 'HIT List'[EffortEstimate] = "Extra Large", "Hard Slogs",

'HIT List'[Priority] = "4 - Low" && 'HIT List'[EffortEstimate] = "Extra Large", "Hard Slogs",

'HIT List'[Priority] = "5 - Planning" && 'HIT List'[EffortEstimate] = "Extra Large", "Hard Slogs"

Hope this gives you enough information.

Regards,

SwapnilS