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

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

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

        Hi Jay

        thanks for coming back to me. Ok let me explain again .. sorry for the confusion.

         

        the bar graph must be sorted along the x axis by date .. works fine

        however when trying to sort each bar which is segmented by BRANCH from biggest to smallest based on VALUE the error message says it can't sort by two different fields?