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.
jm9999999 , If this is what the requirement is,
Then,
1) This plotted for only 10 values of time.
2) Start by checking the data type of the day/time column.
3) X-axis -> time,
Y-axis-> Other fields
4) On Y-axis column in visualization pane, right click the column that can give the option to select the function that is required. In this case, it is the average function.
If sorting continues, go to the three dots of the visual and sort accordingly.
I had set my day time column to text. When I try to set it to time it drops the name of the day "Monday" and just displays the time and any day after Monday the day/time value errors due to the change in type. How would I make the format "nameOfDate" + "time" be considered time. or at the very least be similarly treated as an index or a timestamp.
There is no option to just have name of date + time. Have add the date, or create a column that can provide the distinction. In terms of text it will always sort the values one way or another.
Remember to use a 24-hour clock.
Is there anyway I can go about making a graph with these axis in power BI?
