Fatema Motiwala
Last answered:

30 Mar 2023

 Posted on:

14 Nov 2022
1

Can we sort the country column ?

in Power BI / Task Four, Part 1

Can we sort the country column alphabetically, as we had done for month name in the previous videos

1 answers ( 0 marked as helpful)
Raja Ikhsan Halomoan
Posted on:

30 Mar 2023
0

Yes, you can.  Use this DAX formula :

SortedTerritory = 
RANKX(dim_SalesTeritory, [SalesTerritoryRegion], , ASC, Dense)

But Dimitar didn't follow the alphabetical order, he customized it

Submit an answer

related questions

Peter Salib
0
16
Resolved: the total sales amount for USA comes as 9M not 9.39M as in the video so can you please advise?!
Mohammad Mazhar Zahid
1
8
Resolved: Task Four, Part 1 (Can't Change to Orientation)
feras
0
6
Resolved: can you explain it again please
Travis Tester
0
6
Can Conditional Formatting be Applied to Titles or Tool-Tips?
Thomas Okanya James
0
6
Error Message while trying to rename column
Silvia Duque Moro
0
6
Where can I find the image for the task?
Occélus Orac
0
6
Resolved: Task Four Part 1 - My DAX Code for CountryOrder Column
Francois Chouinard
1
4
Can't find the images
JAZEELA P
1
4
Resolved: Can't click load or transform data button
Abdennour KHORCHANI
0
4
Resolved: Dynamic Title for Products sales by country
Jacobo José León Peña
0
2
Resolved: Can't hierarchies be created by users?
Callum Shaw
0
2
Resolved: How was dim_Date first column name generated?