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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Field parameters - Default sorting order resets When there is a Legend in the Visual!

Similar thing to (Ticket ) happens when I use legend in the stacked bar (or column) chart. If the legend is not in place, then the Sorting by measure works fine. If I add a legend, then the sort order by measure gets removed averytime I change the parameter (measure) between count and value. See below: 

 

StandaRubina_0-1715848386221.png

 

 

 

StandaRubina_2-1715848386075.png

 

Please fix this so this visual is useable for the Field Parameters. Thanks.

Status: Delivered

Hi @StandaRubina .

 

It's a known limit.When a Field Parameter is used to swap fields in a Visual, the Visual will drop some related information like Sort direction and Drill/Expand state.

 

If you would like to suggest feature improvements, you may vote the idea and comment here to improve this feature. It is the right place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Community Support Team _ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Delivered

Hi @StandaRubina .

 

It's a known limit.When a Field Parameter is used to swap fields in a Visual, the Visual will drop some related information like Sort direction and Drill/Expand state.

 

If you would like to suggest feature improvements, you may vote the idea and comment here to improve this feature. It is the right place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Community Support Team _ Caitlyn

allyklee
Frequent Visitor

We found a fix by adding a blank measure into the tooltips field then sorting on that 🙂  Found that little gem here https://community.fabric.microsoft.com/t5/Desktop/Sort-Visual-on-Field-Parameter/td-p/2520955

StandaRubina
Regular Visitor

It doesnt work for me or I didnt get how to set it. Can you pls advise I have got it correctly? It doesnt do anything (and doesnt maintain the ordering based on the selected measure).
Measure: 

Blank = BLANK()

Setting: 
StandaRubina_0-1717395391592.png

 

Thanks a lot for info, Stan. 🙂