Forum Discussion
Using a Date Table for a Visualisation
You do need a date table! Luckily, they're pretty easy and there are plenty of people who have posted scripts to create date tables with all the columns you'll ever need! Watch the video linked below (for the how) and the date table I use is from the second link here!
https://www.youtube.com/watch?v=WybnTHDl-AM
https://radacad.com/all-in-one-script-to-create-date-dimension-in-power-bi-using-power-query
Syk Firstly a Big Thanks for the advice on the date table. That has solved many other issues that I was not actually posting about - So thanks again.
ToddChitt Im still delving into the measures etc. Whilst taht is ongoing I atr least have a visulisation with some basic counting and conditinal formatting.
Thougg I could not seem to get my lets Milesstones (green icons) to appear in Date order frpm Left to Right.
All likley related to sorting etc
To fix this sorting issue you show, you need another column, maybe an INT, with values 1, 2, 3, that correspond to the Task. Then in Column Tools, make sure Task has a "Sort by Column" that is that INT. That puts "Some Task 10" AFTER "Some Task 9". Optioally, add a leading zero in the Task name: "Some Task 01"