Custom Sort axis

Question

I want to remove the 1.2.3. (which I added manually in the database) and sort by Delivery, CE, Firm, and Total. I’ve created a custom sort table to define the sort order. However, I think because the "Total" is created using a measure (as shown above), and I’ve linked the 311 category total to the new table and selected it on the axis, the "Total" is not appearing on my clustered chart.

What steps should I take to remove the 1.2.3. and ensure that the "Total" is displayed correctly?

Thanks.

Regards,

YY

samwiseowl · Answer

Hi&nbsp;YYlee&nbsp;Can you show us the measure please.My guess is you need to remove the new filter caused by the sorting column.For example if I had the Month Name and sorted by the Month Number I have to remove both filters to return the total:All Month sales =Calculate( [Sum Quantity], AllSelected(calendar[Month],Calendar[Month Name])

yylee · Answer

Hi Sam,&nbsp;Which measure you mean?

samwiseowl · Answer

Hi&nbsp;YYlee&nbsp;this one:However, I think because the "Total" is created using a measure

yylee · Answer

Measure 2 = if(SELECTEDVALUE('New Table'[Categories])="Total",CALCULATE(SUM('Total'[Week per month]),ALL('New Table'[Categories])),SUM(Total[Week per month]))

samwiseowl · Answer

Hi&nbsp;YYlee&nbsp;I would assume something like this:Total Measure&nbsp;=&nbsp;if(SELECTEDVALUE('311 category total[311 category total])="Total" --if new column is total,CALCULATE(--Change the filters&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM('Total'[Week per month]) --sum this&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ALL('311 category total')) --remove the filter from new table,SUM(Total[Week per month])) --Otherwise sum current filter

Forum Discussion

Custom Sort axis

6 Replies

Related content

Custom sort on x-axis

Custom Sort Axis

Sorting X- axis based on Month-Year slicer selection

X Axis Custom sort

Custom Sort by x-axis legend