Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

graph trouble summing

     I have a graph that looks like this currently                     .    This is the data for the chart above-------------    ID Frequency Requirement Level Values in chart 1 1 ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    Drag the following calculated column to Legend.

    Column =
RANKX (
    FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ),
    Table1[Requirement Level],
    ,
    DESC,
    DENSE
)
NAOS's avatar
NAOS
Advocate III
7 years ago

Hi!

Im sure I replied to this post already...Dunno what happend with it haha.
Anyway, it isnt clear what you want to achieve with that visual. the visual is correct. Is using the "Frequency" field as a Category, so that gives us 4 Frequencies {1, 15, 30 ,400}. Thats why you have only 4 labels, which are the sum of "Requirement Level"

If "Requirement Level" is a Categorical variable, and frequency is not (but it looks like it is too...), change "Requirement Level" to data type "Text" and use Frequency in the Y axis instead. 

Plus, Im sure that's not the visual for that data...
Anyway, let me know how everything goes.