Forum Discussion

sclencioco's avatar
sclencioco
Helper I
9 years ago
Solved

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!

13 Replies

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

  • 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)

     

    • Douwe's avatar
      Douwe
      Helper 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.

       

      • sclencioco's avatar
        sclencioco
        Helper I

        Hi Douwe

         

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