Forum Discussion

goalie_'s avatar
goalie_
Helper III
6 years ago
Solved

Quadrant chart with predetermined quadrants

Hi All,

 

I have a long list of attribute each having an assigned quadrant of 1-4 using predefined rules. Is there a way I can plot them so they appear on the quadrant chart (by MAC) without having to put the anything for x or y axis?

 

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi goalie_ ，

     

    Create 2 measures similarly as below:

    X Measure = IF(MAX('Table'[Attribute]) in {"A1","A2","A3","A7"},SUM('Table'[Value])+SUMX(ALL('Table'),'Table'[Value]),MAX('Table'[Value]))
    Y Measure = IF(MAX('Table'[Attribute]) in {"A1","A2","A3","A4"},SUM('Table'[Value])+SUMX(ALL('Table'),'Table'[Value]),MAX('Table'[Value]))

    And you will see:

    All of the attributes have been plotted in the predetermined quadrants.

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

5 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi goalie_ ，

     

    Do you mean "Quadrant Chart by MAQ Software"? 

    Based on my test,without x and y axis value,it is not available to create the quadrant chart,and it will return an error as below:

     

    Could you show me some sample data with expected output?I would suggest you create a calculated column to make the quadrant showing as predetermined.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
  • goalie_'s avatar
    goalie_
    Helper III
    6 years ago

    amitchandak v-kelly-msft  for example if I have data as below

     

    AttributeQuadrant
    A11
    A21
    A31
    A42
    A53
    A63
    A74

     

    Can I plot the attributes(randomly) within that quadrant? Or should I be looking at a different visual

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      6 years ago

      Hi goalie_ ，

       

      Create 2 measures similarly as below:

      X Measure = IF(MAX('Table'[Attribute]) in {"A1","A2","A3","A7"},SUM('Table'[Value])+SUMX(ALL('Table'),'Table'[Value]),MAX('Table'[Value]))
      Y Measure = IF(MAX('Table'[Attribute]) in {"A1","A2","A3","A4"},SUM('Table'[Value])+SUMX(ALL('Table'),'Table'[Value]),MAX('Table'[Value]))

      And you will see:

      All of the attributes have been plotted in the predetermined quadrants.

      For the related .pbix file,pls see attached.

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!
      • goalie_'s avatar
        goalie_
        Helper III
        5 years ago

        thanks kelly. I also have another column for the attributes where I have them in category 1, 2, and 3. I want to plot the individual points but have them be the same color if they're in the same category. Multiple attributes can fall within a category.

         

        So A1, A2, and A4 can fall into category 1;

        A3, A5, A7 fall into category 2

        A6 is in category 3.

         

        However the visual takes the aggregate of the ones that fall in the same category. Is there a way to use the legend axis field so it doesn't take the aggregate of the attributes that fall into the category?