Forum Discussion

SwapnilS's avatar
SwapnilS
Frequent Visitor
4 years ago

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 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. 

 

 

Need Help

8 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

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

    • SwapnilS's avatar
      SwapnilS
      Frequent Visitor
      4 years ago

      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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    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.

  • SwapnilS's avatar
    SwapnilS
    Frequent Visitor
    4 years ago

    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's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Hi,

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