Forum Discussion
ncbshiva
Advocate V
Advocate VSort the Order in the Stacked Bar chart
Hi Team, My requirement is to sort the order in the Stacked bar graph as shown below. As you can see in the first stacked bar graph the Medium with value 3 is on top and then Hard with value 2 i...
Hi ,
I got the solution , i tried to create separate measures for hard,medium and easy and use them in Value box and arrange these measures as added so that it sorts the column charts as required.
mwegener
Most Valuable Professional
Most Valuable ProfessionalHi,
you can change the sort order, using the "Sort by Column" button.
Create a column with the sort order for each category ...
e.g. 3 (Hard) > 2 (Medium) > 1 (Easy)
... and use these with "Sort by Column" as surrogate sort column
best regards
Marcus
ncbshivaHi,
Here my category column is calculated one and below is the formula for it.
IFCondition = IF('Capability Data'[Difficulty to Fill]="Hard" && 'Capability Data'[How large is the gap to fill]="1";"Hard";IF('Capability Data'[Difficulty to Fill]="Hard" && 'Capability Data'[How large is the gap to fill]="2";"Hard";IF('Capability Data'[Difficulty to Fill]="Hard" && 'Capability Data'[How large is the gap to fill]="3";"Hard";IF('Capability Data'[Difficulty to Fill]="Medium" && 'Capability Data'[How large is the gap to fill]="3";"Hard";IF('Capability Data'[Difficulty to Fill]="Medium" && 'Capability Data'[How large is the gap to fill]="1";"Medium";IF('Capability Data'[Difficulty to Fill]="Medium" && 'Capability Data'[How large is the gap to fill]="2";"Medium";IF('Capability Data'[Difficulty to Fill]="Easy" && 'Capability Data'[How large is the gap to fill]="3";"Medium";IF('Capability Data'[Difficulty to Fill]="Easy" && 'Capability Data'[How large is the gap to fill]="1";"Easy";IF('Capability Data'[Difficulty to Fill]="Easy" && 'Capability Data'[How large is the gap to fill]="2";"Easy";BLANK())))))))))And if i create a new calculated field for the sorting and use that in the Sort by columns , i am getting below error.