Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous,
Drag the following calculated column to Legend.
Column = RANKX ( FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ), Table1[Requirement Level], , DESC, DENSE )
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.
Sorry for the confusion, here is a picture of what I am trying to achieve.
Is there a way to have it like this, I got these dots by creating an index of the data
This is my set up for the graph above, (without the blue lines of course) --->
Thank-you 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 )
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |