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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sclencioco
Helper I
Helper I

show data descending

Hello,

 

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

 

Untitled.jpg

 

 

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

1 ACCEPTED SOLUTION

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?
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/

 

 

Markus Ehrenmueller-Jensen
@MEhrenmueller

View solution in original post

13 REPLIES 13
sclencioco
Helper I
Helper I

Hi @MEhrenmueller

 

Please see screenshot for your reference.

 

Untitled110816.jpg

 

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. 

 

Capture111016.JPG

@sclencioco

 

 

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

 

asdf.png

@Douwe

 

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.

@Douwe

 

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
@MEhrenmueller

Filip
Douwe
Helper I
Helper I

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

Hi,

 

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.

@sclencioco

 

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.

 

99.PNG

 

Then set order in chart.

 

00.PNG

 

Regards,

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?
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/

 

 

Markus Ehrenmueller-Jensen
@MEhrenmueller

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors