Forum Discussion
graphic representation
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Good morning,
I would like to represent this graph.
a) evolution of the distance compared to the month
b) draw the line from zero to the maximum distance
c) if I select two identifiers which do not have the same max distance, a message is displayed saying "the two identifiers do not have the same max distance", in this case only the curves will be displayed and not the straight line
example: for a selected ID I would see the evolution of the distance and the line with the initial point up to the max distance,
Thank you for your help
| ID | distance | distance_max | month | test_1 |
| 125 | 12000 | 12 | 25 | |
| 125 | 15000 | 24 | 56 | |
| 125 | 17000 | 36 | 87 | |
| 125 | 18000 | 48 | 95 | |
| 125 | 20000 | 80000 | 60 | 108 |
| 140 | 13000 | 12 | 78 | |
| 140 | 14000 | 24 | 145 | |
| 140 | 17000 | 36 | 189 | |
| 140 | 22000 | 48 | 197 | |
| 140 | 25000 | 100000 | 60 | 200 |
| 870 | 12000 | 12 | 78 | |
| 870 | 11000 | 24 | 89 | |
| 870 | 15000 | 36 | 98 | |
| 870 | 21000 | 48 | 102 | |
| 870 | 25000 | 150000 | 60 | 120 |
| 145 | 12000 | 12 | 145 | |
| 145 | 13000 | 24 | 160 | |
| 145 | 17000 | 36 | 170 | |
| 145 | 18000 | 48 | 180 | |
| 145 | 22000 | 80000 | 60 | 200 |
| 170 | 12000 | 12 | 48 | |
| 170 | 13000 | 24 | 79 | |
| 170 | 17000 | 36 | 85 | |
| 170 | 18000 | 48 | 98 | |
| 170 | 22000 | 60 | 145 | |
| 170 | 24000 | 91000 | 72 | 170 |
| 180 | 12000 | 12 | 48 | |
| 180 | 13000 | 24 | 79 | |
| 180 | 17000 | 36 | 85 | |
| 180 | 18000 | 48 | 98 | |
| 180 | 22000 | 60 | 145 | |
| 180 | 24000 | 20000 | 72 | 170 |
- lbendlin
here is how your data plots at the moment. Please indicate which changes you require.
Should they all start at (0,0) ?
hi lbendlin thank you for your feedback, I want to draw a line which starts from 0 up to the maximum value for each ID, like that as soon as I select an ID I must see its curve which turns around the line, if the curve is above the right it is a red color, if the curve is below it is green
- lbendlin
Sorry, I am not following. Can you guarantee that the values for each line always increase? One line has more data points than the others - does that matter?
as soon as I select an ID I must see its curve which turns around the lineI cannot visualize that - can you please explain?