Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Stacked Chart Sort

I have read through quite a few of posts on this subject but none seem to solve my issue. I have the below table and have created Graph 1 using COUNT([Status]). However, I would like Overdue to be the first the bar rather than error. Therefore I created individual measures to count each category status i.e. CALCULATE(COUNT([Status]),filter([Status]="Pending")) which is shown in Graph 2. My issue is I want to sort the x-axis by the total count i.e. James, Daniel then Charlie (from Graph 1) but the bars sorted Overdue, Pending then Error (from Graph 2). Is there a work around without adding spaces to the the fields Overdue, Pendign and Error?

 

NameReport NumberStatus
Daniel1Overdue
Daniel2Overdue
Daniel3Pending
Charlie1Error
Charlie2Pending
James1Overdue
James2Pending
James3Pending
James4

Pending

 

 

Thanks,

 

Jack

Need Help
  • kaiserj's avatar
    kaiserj
    7 years ago

    Hi, 

     

    it is correct to create single measures with the Status for the order in the legend . 

    To sort the bars by the total count you can drag the Status to the Tooltips area (use the Count in the drop-down menu of the field) and sort by it.

    Regards,

    Julian

1 Reply

  • kaiserj's avatar
    kaiserj
    Advocate I
    7 years ago

    Hi, 

     

    it is correct to create single measures with the Status for the order in the legend . 

    To sort the bars by the total count you can drag the Status to the Tooltips area (use the Count in the drop-down menu of the field) and sort by it.

    Regards,

    Julian