Forum Discussion
Quadrant chart
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 effo...
What would be your desired definitions (and sort order) for the X and Y axes ?
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