Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |