How to add a SIMPLE SORT BUTTON // Switch to Asc or Desc, Change Sort By // Power BI Guide in 2023

  Рет қаралды 5,279

Fernan

Fernan

Күн бұрын

Пікірлер: 26
@akshaykodekal8483
@akshaykodekal8483 Жыл бұрын
Your informative videos are amazing and I love watching them.
@rapatel1642
@rapatel1642 2 ай бұрын
Great video how do you do the sort on fields and not measures.
@shahzadkheros
@shahzadkheros Жыл бұрын
Easy and Efficient! great work mate
@lightbult
@lightbult 5 ай бұрын
only 2min in and i already like this video. I love that u show the end result at the very beginning
@unnikrishnansanthosh
@unnikrishnansanthosh Жыл бұрын
great one, thank you for sharing
@JoseOmarSanchezAvila
@JoseOmarSanchezAvila 9 ай бұрын
Genius! Thank you, i haven't found a similar solution so far
@pthapa55
@pthapa55 Жыл бұрын
Thanks for great tip.
@arbazahmad7177
@arbazahmad7177 Жыл бұрын
Excellent 🎉thanks for sharing 👍
@svetlanaspitsyna4307
@svetlanaspitsyna4307 Жыл бұрын
Is it possible to sort data by two columns in two steps? For example, I have a matrix with categories and sales, and in rows below categories I have months, so I want to sort categories by volume, but when I press + on a category I want to see months in chronological order, but I see them sorted also by volume.
@cathrerinezetadrones3169
@cathrerinezetadrones3169 Жыл бұрын
Very nice!!
@pavankalyanbandi1539
@pavankalyanbandi1539 Жыл бұрын
Thanks 🙏
@Scorpian22k
@Scorpian22k Жыл бұрын
Perfect! But in my case its a matrix with double column headers . Eg: Order, Sales, unit price (for last week & last month as its separated my headers (last week & last month) . So instead of creating 3 measures it will have +3 measures more? Any idea on custom sort for this type of scenario?
@yaser.taherkhani
@yaser.taherkhani Жыл бұрын
Very nice
@hichamezznati2646
@hichamezznati2646 Жыл бұрын
thanks a lot for this amazing video and trick. here is an other way to have the same result . table for sorting order : Table = {(1,"△"),(-1,"▽")} with respectively 2 colums : C1,C2 if we note SM the selected one among the 03 measures the ranking is = SELECTEDVALUE(Table[C1])* RANK(dense,ALLSELECTED(Categories[categoriesname],ORDERBY([SM],ASC))
@perfectionist6624
@perfectionist6624 11 ай бұрын
Can we do this with existing columns. I don't have measures in table. Please help
@krishraj4
@krishraj4 Жыл бұрын
thanks, can it be extended with multiple columns and to other visuals like matrix and any small multiples - where we have a lot of limitations with sorting within a group?
@Jibril-e7v
@Jibril-e7v 5 ай бұрын
Amazing video ! Thanks for sharing it. How we can apply this solution to a field parameter table allowing to switch between different dimensions.
@gauravguliani358
@gauravguliani358 Жыл бұрын
At 1:30 in Intro the default solution of shift by 2nd column selection to sort- works only for Table visuals Not for Matrix ones
@Scorpian22k
@Scorpian22k Жыл бұрын
If there is column headers then it will not. Any tips on how you are handling?
@lojee6753
@lojee6753 Жыл бұрын
amazing
@pavelandreev6023
@pavelandreev6023 Жыл бұрын
Nice
@saikumarp-s2t
@saikumarp-s2t Жыл бұрын
How could we get the keyboard for the adding the icons
@saikumarp-s2t
@saikumarp-s2t Жыл бұрын
I have a doubt for one scenario. Please let me know if you have any idea.customized tooltip not showing for total when hover in mtraix visual
@dmitriyivanov1309
@dmitriyivanov1309 11 ай бұрын
Good afternoon. I would also close the table with an invisible picture so that the user would not be able to sort by another column.
@venusv4698
@venusv4698 Ай бұрын
I dont want user to sort the table, how can i do that?
@gauravguliani358
@gauravguliani358 Жыл бұрын
Also your solution did not show if it works when we select multiple columns
Air Sigma Girl #sigma
0:32
Jin and Hattie
Рет қаралды 45 МЛН
EVERYTHING YOU need to know about SORTING in POWER BI
16:45
How to Power BI
Рет қаралды 64 М.
3 Hacks to Work Faster in Power BI
25:39
How to Power BI
Рет қаралды 72 М.
STOP Using Power BI Default Cards - DO This Instead!
21:01
From Zero2BI Hero with Stelian
Рет қаралды 10 М.
How to share a Power BI report in Teams
11:23
Access Analytic
Рет қаралды 29 М.
Air Sigma Girl #sigma
0:32
Jin and Hattie
Рет қаралды 45 МЛН