cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Collin Member
Member

graph trouble summing

 

 

 I have a graph that looks like this currently

 

Capture.PNG                  .   

This is the data for the chart above-------------

 

 IDFrequencyRequirement LevelValues in chart
1170point 1
115106?
130106?
11596?
13096?
130106?
140096 point 4

  

I would like it to show all 7 points (not just 4)and not sum diffrent things. I have made the frequency and requirement columns set to not sum from the modeling tab. "values in chart "column is not part of graph.

Thanks for the help. 

 

- Collin

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: graph trouble summing

@Collin,

 

Drag the following calculated column to Legend.

Column =
RANKX (
    FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ),
    Table1[Requirement Level],
    ,
    DESC,
    DENSE
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
NAOS Regular Visitor
Regular Visitor

Re: graph trouble summing

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.

Collin Member
Member

Re: graph trouble summing

Sorry for the confusion, here is a picture of what I am trying to achieve. 

 

 

 

Capture.PNG

 Is there a way to have it like this, I got these dots by creating an index of the dataCapture.PNG

 

This is my set up for the graph above, (without the blue lines of course)       --->

 

Thank-you for the help.

 

- Collin

Community Support Team
Community Support Team

Re: graph trouble summing

@Collin,

 

Drag the following calculated column to Legend.

Column =
RANKX (
    FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ),
    Table1[Requirement Level],
    ,
    DESC,
    DENSE
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Collin Member
Member

Re: graph trouble summing

That did it, thankyou very much.

If i may ask what exectly the column does as far as what is EARLIER, FILTER, RANKX, DESC, DENSE. 

Tried looking through it but doesnt make sense. 

Thanks again .

  -Collin

Collin Member
Member

Re: graph trouble summing