Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

show data descending



I would like to show the least on the top of the visuals (sorted descending)





It still shows on the bottom part. Can you help me out on this. Thank you!


Could you support us with a screenshot of the options you have at "...", so we try to help from there?


Does the following documentation help you?



Markus Ehrenmueller-Jensen

View solution in original post

Helper I
Helper I

Hi @MEhrenmueller


Please see screenshot for your reference.




Also, formula for ZERO is shown below


ZERO = IF(count('2015_POSdata'[COUNT])>0,COUNT('2015_POSdata'[COUNT]),0)


I managed to reproduce your problem and solve it:


The sort button looks like one button, but actually there are two. 'Z->A' and 'Sort By XXX' are two different buttons with different functionalities. By clicking on Z->A you can reverse the order, while clicking 'Sort By XXX' will activate or deactivate the sorting.


Let me know if this worked for you.


Hi @Douwe


How can I use Z -> A functionality if the options given are only two as per my image below. 






First activate the sorting by clicking on 'Sort by ZERO', afterwards the Z->A functionality becomes active.





It descends by station name, not the values. If its possible that the values be arranged descending.


Thank you.

Sorry I can't help you any further with the information you are providing. Please provide your power bi file so that we can have a look.



How can I provide you with my pbix file? can't search for attach files here as I reply.  Sorry I'm just new in community.


Thank you.

Upload it eg. to Onedrive and share the link with us.

(Remember to first remove any sensitive data from the file.)

Markus Ehrenmueller-Jensen

Helper I
Helper I

Click on the triple dots in the visualization and change the order by clicking once more on Sort by xxx



It still does not sort the way I expected it to sort. Hence, it sorted chronologically.


Hooping I could make it the way I wanted it to be sorted.



Thank you.



You need to select the field on Axis and set it sort by your fact value. It will sort in descending order as you expected.




Then set order in chart.





Could you support us with a screenshot of the options you have at "...", so we try to help from there?


Does the following documentation help you?



Markus Ehrenmueller-Jensen

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors