Forum Discussion
show data descending
Hello,
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?
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/
13 Replies
- DouweHelper I
Click on the triple dots in the visualization and change the order by clicking once more on Sort by xxx
- sclenciocoHelper I
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.
- MEhrenmuellerMost Valuable Professional
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/
- sclenciocoHelper 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)
- DouweHelper I
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.
- sclenciocoHelper I
Hi Douwe
How can I use Z -> A functionality if the options given are only two as per my image below.