vishnu prashanth
vishnu prashanth

Reputation: 419

Sorting the Column Series by date order in Line and Stacked Column chart in Power BI

I have created a Line and stacked column chart for each week.

Since the values are grouped by date in the week, the values are not shown in a proper order of date.

How can I sort it, so that, it is displayed in the increasing order of date?

Attached screenshot with an explanation. How can I sort the column series with respect to date? need to sort the column series/legend value in the increasing order of date

Upvotes: 0

Views: 1728

Answers (1)

redmary
redmary

Reputation: 101

You can create a new calculated column of int values (for instance:1901,1801,1701 etc) and sort the column you want by that calculated column from the Sort by Column option in the Modeling tab.

Upvotes: 2

Related Questions