Legend showing in wrong order - stacked bar graph

[JamesGordon]

Hi,

My legend is displaying in the wrong order. Screenshot below showing the graph and also my DAX.

I cant find a way to put the legend into the order: 0-90 Days, 90-180 Days, 180-365 Days, 365+?

Can someone help!!

Thanks

[Anonymous]

That's because in the table that stores your brackets you also have to have a (hidden) column that establishes the order among them. And once you do have it, you have to tell PBI that you want to sort this column by that column.

Also, storing everything in one big table is a sure way to have bugs in the model all over the place and not even be aware that they exist. Please use the star schema.

Best
D