Forum Discussion
show data descending
- 9 years ago
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/
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.
- sclencioco9 years agoHelper I
Hi Douwe
How can I use Z -> A functionality if the options given are only two as per my image below.
- Douwe9 years agoHelper I
First activate the sorting by clicking on 'Sort by ZERO', afterwards the Z->A functionality becomes active.
- sclencioco9 years agoHelper I
It descends by station name, not the values. If its possible that the values be arranged descending.
Thank you.