Forum Discussion
Visual - distributions / scattered
Hi Guys,
I wan to visualise the disctribution of available number of cars in the garage during the nightstop - starting of arrival and departure times. For example - number of available cars per every 15 mins between that nightsotp from 20:00 till 08:00 next morning. See a csv dataset example here . Any ideas? (something like scattered/ circle in exel graphs)
2 Replies
kmilarov , You have create a date table and merge it with time table of every 15 Mins
Power Query- List.Times- Create Time Table: https://youtu.be/-pxMpTdnTVc
Date Table - https://youtu.be/so_A22HXbwM
Power Query cross Join - https://youtu.be/7MvROGObBYk
or use
List.DateTimes- https://youtu.be/3UBxsIvlcRQ
Then use the same approach as between dates
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
Thank you amitchandak . I created the Date/Time table with 15 mins intervals, but cannot make the data /cars distribution within the times. The Linked above does not help. So, I need to have the sum/total available Cards per every 15 mins interval. But cannot make it..
