Forum Discussion

goalie_'s avatar
goalie_
Icon for Helper III rankHelper 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...
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!
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity 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_
Icon for Helper III rankHelper III
6 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?