undefined

[cham]

Hi,

I have my data set as below,

Date                        State        Count

19/Sep/2019           SYD           34

19/Sep/2019           MEL           454

19/Sep/2019           SYD           56

19/Sep/2019           MEL           24

19/Sep/2019           SYD           45

i WANT TO SHOW MY DATA SET AS BELOW, Can anyone show me how to do that?

Date                        State        Count

19/Sep/2019           SYD           34

                                SYD           45

                                SYD           56

                                MEL           24

                                MEL           454

[Anonymous · Accepted solution]

Hi @cham ,

Current power bi visuals not allow you to setting multiple sort order fields, you can consider to sort them on query table side and add index column.

    #"Sorted Rows" = Table.Sort(#"Changed Type",{{"Date", Order.Ascending}, {"State", Order.Descending}, {"Count", Order.Ascending}}),
    #"Added Index" = Table.AddIndexColumn(#"Sorted Rows", "Index", 1, 1)

After these steps, you can use index and originale table fields to create table visual to achieve your requirement.

Notice: don't forget to modify aggregation mode of index to 'don't summarize'.

Regards,

Xiaoxin Sheng