Sorting by Week in bar chart

[pittouti]

Hello everybody,

I will need your help please

I have a graph and the x-axis is expressed in Year / Week

the problem is that I can't seem to sort through these weeks

I tried all the possible sorting options, but no result

[Prashant_N]

Hi,

In sorting tab of chart you can enable custom sort and pass your week field.

Might help you

Regards,

Prashant

[pittouti]

when I put the x-axis only the sorting is correct but as soon as I put the formula of the y-axis the sort is wrong

[Prashant_N]

Hi, Are you using calculated dimension on Y axis? or normal dimension.

[pittouti]

Calculated dimension

Sum (xxxx)

[pittouti · Accepted solution]

I found the solution

you had to use combo chart and not Bar chart

Thank you