Forum Discussion
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 | 70 | point 1 |
| 1 | 15 | 106 | ? |
| 1 | 30 | 106 | ? |
| 1 | 15 | 96 | ? |
| 1 | 30 | 96 | ? |
| 1 | 30 | 106 | ? |
| 1 | 400 | 96 | 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
Anonymous,
Drag the following calculated column to Legend.
Column = RANKX ( FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ), Table1[Requirement Level], , DESC, DENSE )
5 Replies
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.Anonymous,
Drag the following calculated column to Legend.
Column = RANKX ( FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ), Table1[Requirement Level], , DESC, DENSE )
