Sorting by another column

[FlowViz]

Hey Guys,

I have a line chart where I'm showing the data points for items in a particular column (ColumnName):

I want to be able to sort by ColumnOrder, but getting the following error:

Data looks like so:

Is there anyway around this?

[FlowViz]

Ah so actually taking Done out of the dataset (as it's not in the chart) would be the best idea 🙂

[FlowViz]

I'm not quite sure I understand. In the report I only want to have the chart, I just put the table to the right hand side to show the underlying data.

So I want the chart to have categories of:

In Progress | Review | Sign off | Ready for Prod | In Prod or look like this:

[Ashish_Mathur]

Hi,

What do you not understand in my previous post?

[FlowViz]

Sure thing - here it is

[Ashish_Mathur]

Hi,

I see 2 problems with the numbers appearing in the ColumnOrder column.  For Done and Review the number is 3.  This cannot be the case - assign different numbers.  Also, Done cannot have 2 numbers - 3 and 7.  Correct for that as well.  After that click on any cell in the ColumnName column and sort it the ColumnOrder column.

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.