Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
rpinxt
Impactful Individual
Impactful Individual

Sorting problem when using parameter fields

rpinxt_1-1664980042415.png

So I have a matrix that show my top 5.

Now I first only had Qty in and sorted it from high to low (so the biggest number on top).

 

A good idea seemed to make field parameter so I could switch between Quantity and USD.

So that is what I did.

And it works fine when I choose Qty I get Qty and for USD it shows USD.

 

However it will not sort anymore from highest to lowest because I switch between Qtd and Value.

Does anybody know a way around this?

1 ACCEPTED SOLUTION
quentin_vigne
Solution Sage
Solution Sage

Hi, 

 

Unfortunately this is something that is not possible yet. 

 

The issue already has been reported : https://community.powerbi.com/t5/Issues/Field-Parameter-breaks-sorting-order-in-visuals/idi-p/281687...

 

- Quentin

View solution in original post

4 REPLIES 4
rpinxt
Impactful Individual
Impactful Individual

@amitchandak @quentin_vigne 
Ok guys, thanks for pointing this out.

quentin_vigne
Solution Sage
Solution Sage

Hi, 

 

Unfortunately this is something that is not possible yet. 

 

The issue already has been reported : https://community.powerbi.com/t5/Issues/Field-Parameter-breaks-sorting-order-in-visuals/idi-p/281687...

 

- Quentin

amitchandak
Super User
Super User

@rpinxt , I think, I also observed this issue. Please log an idea - https://ideas.powerbi.com/ideas/

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.