Forum Discussion

MarcUrdang's avatar
MarcUrdang
Icon for Post Patron rankPost Patron
6 years ago
Solved

Sorting in a stacked bar chart

Hi .. I have a stacked bar chart where I sort the x axis by date which works fine. However each bar is stacked by a value per branch. How do I sort each column by the highest value at the bottom up t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi MarcUrdang ,

 

You can use RANKX() function to create a measure to sort specific column.

Please check the following steps.

1# Create measures as below.

SUM = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[type]="x"))

Measure = RANKX(ALLEXCEPT('Table','Table'[type]),[SUM])

2# Add the measure to Tooltips field and sort the visual by the measure.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MarcUrdang's avatar
MarcUrdang
Icon for Post Patron rankPost Patron
6 years ago

Hi .. I don't think I am understanding the steps:

I have a value and a category:  

   category = branch names or BranchRelated

   value = Nashua Page Count

 

I have created measure #1:  but not sure why I have to filter on only ONE of the branches? I probably have this incorrect

Your solution = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[type]="x"))

My solution =    CALCULATE(SUM(Nashua[Nashua Page Count]),FILTER(Nashua,Nashua[BranchRelated]="CPT"))
 
I tried to create measure #2:  not working 
Your solution = Measure = RANKX(ALLEXCEPT('Table','Table'[type]),[SUM])

My solution = from Calculae onwards its underlined in RED

RANKX(ALLEXCEPT(Nashua,Nashua[BranchRelated]),[CALCULATE(SUM(Nashua[Nashua Page Count]),FILTER(Nashua,Nashua[BranchRelated]="CPT"] 
  • MarcUrdang's avatar
    MarcUrdang
    Icon for Post Patron rankPost Patron
    6 years ago

    I actually now got the calc to work ... but not the sorting 

  • MarcUrdang's avatar
    MarcUrdang
    Icon for Post Patron rankPost Patron
    6 years ago

    • MarcUrdang's avatar
      MarcUrdang
      Icon for Post Patron rankPost Patron
      6 years ago

      Hi again .. I don't mean to be rude as I know you have helped me so much thus far .. but as I am now under immense pressure to get this right .. I need to repost so hopefully someone can help me in the next 30 minutes or so.

       

      thanks for your help thus far.

      regards,
      Marc

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi MarcUrdang ,

         

        I'm not sure if i understand you correctly, I thought you want to sort the visual by one of the types in a same column but it turns out that you want sort the visual by multiple columns? If so you may check the topic below.

        https://community.powerbi.com/t5/Desktop/Sorting-by-multiple-columns/m-p/536884#M251918.

         

        Best Regards,

        Jay

        Community Support Team _ Jay Wang

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.