Sort values by date range on X Axis (Line and Stacked Column Chart)

[RickSmalls83]

Hi,

 I want to show a column chart that presents a list of Construction site names on the X Axis - which are sorted in an order of when they were completed;

I have the 'Site Name' on the X Axis, but it seems to be auto sorting it in Alphabetical order, when really i want it to be sorted by a column i have that contains specific dates, ranginf from '02 July 2020' to '19 May 2022'. I would also like to show what sites have been completed in a different colour?

Thanks,

Rick

[mahoneypat · Accepted solution]

If it's a date column (not text), you can just add it to the tooltips for that visual (or add a measure that returns the date), and then sort the visual by that column/measure (hit the ellipsis on the visual to change sorting behavior).

Also, this article shows one way to color your bars with a measure.

Conditional formatting by field value in Power BI - Power BI Docs

Pat