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

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