Forum Discussion
Line Chart with Time on Y Axis
T0PH3Y ,
Check the data type of the time column and change it to just time. If this doesn't work change the type in power query.
Solution SageIn power Query, select the date column and unpivot[not pivot] other columns. This will create a table with second column being the time column and a table where for a date every time is available. Now when time vs values[The third column] is plotted it will not be the desired result but when the date column is added as legend it should give the desired result for every date available in the date column.
Thank you. I now have the data unpivoted.
However all the data is positioned at the bottom of my graph and not visible. And also the time doesnt show as the Y Axis
- ChiragGarg2512
T0PH3Y Provide some data in tabular format. Will try and get back.
Thanks. Here you go
Date 07:00 08:00 09:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 01/04/2022 2247 1647 1066 967 933 906 952 1015 1153 1310 1662 2065 04/04/2022 2194 1528 761 711 634 621 634 673 770 898 1350 1796 05/04/2022 2146 1419 666 535 502 462 488 538 627 879 1277 1765 06/04/2022 2163 1082 633 585 555 537 564 648 760 1049 1577 1817 07/04/2022 2176 1493 816 701 654 637 633 682 792 1080 1398 1882 08/04/2022 2257 1569 1009 916 894 873 886 983 1110 1380 1614 1860 11/04/2022 2233 1405 919 831 808 779 786 812 877 1089 1358 1877 12/04/2022 2158 1365 842 737 709 670 678 712 778 1017 1388 1773 13/04/2022 2168 1617 894 813 781 751 763 806 883 970 1329 1808 14/04/2022 2149 1567 1053 954 932 902 904 970 1028 1179 1579 1911 19/04/2022 2164 1446 900 834 810 779 778 840 908 1027 1476 1821 20/04/2022 2136 1516 894 786 766 741 757 794 884 1047 1390 1715 21/04/2022 2096 1358 916 817 777 764 772 825 884 1047 1458 1847 22/04/2022 2116 1599 1099 1036 1006 994 1012 1087 1158 1383 1703 1974 25/04/2022 2111 1342 785 641 600 578 588 637 848 1056 1389 1868 26/04/2022 2119 1251 575 486 449 419 431 496 606 1040 1582 1799 27/04/2022 2130 1179 656 568 545 508 521 559 660 957 1382 1748 28/04/2022 2112 1433 753 664 634 616 621 668 743 1218 1575 1829 29/04/2022 2219 1537 992 897 869 844 903 932 1052 1355 1638 1977 03/05/2022 1829 1213 586 497 471 451 477 494 584 758 1101 1658 04/05/2022 436 1121 787 562 527 511 533 610 683 862 1360 1746 05/05/2022 2099 1372 687 551 524 490 514 551 665 890 1497 1795 06/05/2022 2088 1340 859 759 735 718 754 828 929 1137 1488 1858 09/05/2022 2123 1301 640 548 518 489 496 540 645 1016 1202 1820 10/05/2022 2095 1338 571 439 417 390 433 461 580 921 1166 1816 11/05/2022 2079 1426 581 571 550 512 525 598 687 880 1294 1818 12/05/2022 2172 1320 732 585 550 524 514 560 676 805 1284 1812 13/05/2022 2215 1335 997 860 828 806 822 919 986 1301 1514 1958 17/05/2022 2136 1373 571 511 464 440 461 520 609 768 1239 1829 18/05/2022 2141 1220 751 603 581 558 576 657 758 986 1455 1868 19/05/2022 2118 1346 749 606 585 555 582 646 752 1036 1367 1819 20/05/2022 2194 1388 1081 838 809 779 811 811 991 1134 1538 1925 23/05/2022 2153 1343 836 652 624 599 616 634 762 1076 1536 1832 24/05/2022 2177 1406 732 533 464 441 442 501 608 784 1300 1767 25/05/2022 2164 1274 790 640 605 578 589 634 753 946 1481 1843 26/05/2022 2146 1539 818 665 642 603 615 668 868 976 1351 1807 27/05/2022 2151 1645 1036 979 955 934 959 1021 1111 1325 1591 1930 30/05/2022 2205 1538 988 888 863 834 817 850 939 1073 1454 1846 31/05/2022 2167 1444 890 786 755 730 753 784 869 1135 1433 1759 01/06/2022 2205 1540 1024 927 910 885 906 962 1042 1203 1571 1939 06/06/2022 1962 1351 767 703 687 670 676 697 776 940 1217 07/06/2022 2178 1423 743 587 520 509 524 594 727 921 1304 1809 08/06/2022 2185 1475 751 580 552 525 539 604 668 873 1334 1766 09/06/2022 2147 1465 859 704 662 641 647 718 810 1111 1379 1843 10/06/2022 2234 1501 1053 958 920 908 933 991 1160 1252 1639 2007 13/06/2022 2208 1535 920 745 726 698 713 727 820 1000 1403 1883 14/06/2022 2164 1421 668 531 483 448 463 561 647 859 1304 1753 15/06/2022 2157 1482 771 616 588 565 580 634 718 905 1331 1825 16/06/2022 2200 1486 818 659 636 609 639 689 802 978 1460 17/06/2022 2255 1540 1087 966 947 924 938 998 1140 1266 1680 2013 20/06/2022 2120 1401 786 649 610 592 606 628 718 856 1125 1722 21/06/2022 2136 1387 697 548 531 504 486 577 692 886 1341 1773 22/06/2022 2210 1544 906 695 667 645 691 712 817 1026 1449 1870 23/06/2022 2195 1577 971 814 787 758 762 805 916 1207 1475 1895 24/06/2022 2258 1700 1138 1023 992 975 988 1041 1154 1300 1596 2000 27/06/2022 2223 1535 983 818 787 754 745 778 881 1012 1444 1874 28/06/2022 2167 1496 853 718 675 639 652 709 769 937 1322 1834 29/06/2022 2220 1568 895 767 734 690 695 741 927 1013 1417 1839 30/06/2022 2190 1544 917 801 772 720 729 782 941 1158 1504 - ChiragGarg2512
T0PH3Y ,
Check the data type of the time column and change it to just time. If this doesn't work change the type in power query.