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)
Silvia Duque Moro
0
6
Where can I find the image for the task?
feras
0
6
Resolved: can you explain it again please
Thomas Okanya James
0
6
Error Message while trying to rename column
Travis Tester
0
6
Can Conditional Formatting be Applied to Titles or Tool-Tips?
Abdennour KHORCHANI
0
4
Resolved: Dynamic Title for Products sales by country
Francois Chouinard
0
4
Can't find the images