SortBy use as order by any int column

[NehaSha]

Hi All,

I need help for sort by column in Power BI. It’s a graphical representation (Clustered Column Chart Type) based on MMMYY column on axis and Matrix presentation (data show on rows) of data  and columns has MMMYY with values. 

Query represent MMMYY column is as varchar(20) and there is ‘Num’ column as integer on which basis we can do sorting.

Right now Result is 

MMMYY

Apr18

Aug18

Dec18

Feb19

Jan19

Jul18

Jun18

Mar19

May18

Nov18

Oct18

Sep18

MMMYY

Apr18

May18

Jun18

Jul18

Aug18

Sep18

Oct18

Nov18

Dec18

Jan19

Feb19

Mar19

Order by Num

1

2

3

4

5

6

7

8

9

10

11

12

How to sort by NUM in Matrix and Clustered Column Chart  ? 

Thanks for help in advance! 

Thanks,

[NehaSha]

Hi @v-cherch-msft ,

I tried same way, it worked but as per discussion with user they dont want to see Num field in tooltip is there any other way to resolve. 

Thanks,

Neha

[v-cherch-msft · Accepted solution]

Hi @NehaSha 

You may create a Num table.Then link the two tables.Use the MMMYY column in the Num table.

Regards,

[v-cherch-msft]

Hi @NehaSha 

You may link the order table and data table.Then use Num column to sort the MMMYY column.For example:

Regards,

[NehaSha]

Hi @v-cherch-msft ,

Thanks for your reply! 

I tried both below mentioned ways :

1st . select the sort by column and choose Num as by default

2nd . Create a calendar table and columns MMMYY and SortOrder to create a relationship with other table and tried to sort on sortOrder column but didnt work for me. Please suggest!

Thanks for help in advance!

Thanks,

Neha

[v-cherch-msft]

Hi @NehaSha 

Please make sure the num column is in the visual.You may put it in tootips and then sort it.

Regards,