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!