Quadrant chart with predetermined quadrants

[goalie_]

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?

[goalie_]

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

Attribute	Quadrant
A1	1
A2	1
A3	1
A4	2
A5	3
A6	3
A7	4

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

[v-kelly-msft · Accepted solution]

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_]

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?

[amitchandak]

@goalie_ , not very clear. I tried something with scatter

https://youtu.be/Q1vPWmfI25o?t=2847

[v-kelly-msft]

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!