Forum Discussion
Syndicate_Admin
Administrator
AdministratorMake graph MONTH/HOUR
Hello I have a table where I want to see the documents entered according to their exact time. The database has a now () columa to which you drag into a new column only the time (and recognizes it...
Hi Syndicate_Admin ,
You may consider creating two new columns in Power Query Editor to convert [HOURS], [MY] to NUMBER type respectively.
= Number.Round(Time.Hour([Hour])+Time.Minute([Hour])/60+Time.Second([Hour])/3600,6)
And then new a scatter visual:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data