Skip to main content

Power BI

New

Sort by Column Allow Asc or Desc functionality

Vote (1) Share
Jared Rivera's profile image

Jared Rivera on 12 Jan 2024 20:48:37

Basically what the title says.

We create custom ordinals for lots of things, but there are times where we simply need to have numbers (such as age) sorted ascending.

I can filter the visual that way, but it will then also sort all other items on that visual


an example of this would be the following


Priority Age Object

P1 100 John

P1 75 Jim

P1 50 Tom

P1 25 Eric

P2 65 Steve

P2 38 Sonya

P2 33 Marge


I already have an ordinal on my priority

and have that column sorted by that ordinal


But I also want my age to be sorted ascending

if I sort the visual it will break the sorting of priority via sort by column

I also want to apply an ordinal to age, but because there are hundreds of possible numbers here i cant really create an ordinal for it.


Would be nice to be able to just sort it asc or desc.