Forum Discussion
How do I plot a line chart
jm9999999 , In the line visual put the numeric value in y-axis and time value in x-axis[The text].
This will sort the x axis on the basis of the text string. Now in the table section, click on the day/time column[text column], this will open column tools on the menu above. Go to sort column by and sort it by index column.
For ex., in this the city names[Text] are sorted on the basis of city ID[numeric]. The sort column by option is visible by clicking on the city button in table pane.
Is there anyway I can go about making a graph with these axis in power BI?
jm9999999 Something could be done.
Try uploading the data using power Query and add another column of index.
Click transform data in PowerBI desktop. Then Enter Data, after the data is added go to Add column and add index starting from 1. this would order all the texting.
Then the desired result could be achieved.
I've tried this,
I am unable to prevent it from sorting my data points unless I put the index first and sort by index. If I do that it doesn't display the day time on the chart. Double clicking on the current sort by option doesn't disable the sorting.I need the graph in index order but I want the x -axis to display the day time column in index order.
jm9999999 , In the line visual put the numeric value in y-axis and time value in x-axis[The text].
This will sort the x axis on the basis of the text string. Now in the table section, click on the day/time column[text column], this will open column tools on the menu above. Go to sort column by and sort it by index column.
For ex., in this the city names[Text] are sorted on the basis of city ID[numeric]. The sort column by option is visible by clicking on the city button in table pane.
Thank you so much, I have been tearing my hair out over getting this graph right!