Multiple entries on Axis label

[peterderrington]

Hi, 

I have the graph below which shows the dimension (Week Number) and then with the month relative to that week number displaying as an expression but just as Text on Axis.

Obviously there are a couple of times that show as "-" due to that week crossing over two months. Is it possible to show it as "May/June" for example?

Thanks, 

Peter

[Arthur_Fong · Accepted solution]

I can get this but not as expected in May/Jun result.

But this will not have nulls in your dimension.

In dimension, try using calculated dimension with the formula:

Month&CHR(10)&Week

[Arthur_Fong · Accepted solution]

In QS, create a master dimension and insert the expression above.

[peterderrington]

I don'y know whats going on but my computer seems to be classifying everything as the solution when actually we're not there yet.

I initially got a little red squiggly line under the 'week' section of that expression, so i altered it to the dimension of [Week Number] which is the original dimension but that doesn't alter whats showing.

Any ideas?

[Arthur_Fong]

You have a sample app?

[Arthur_Fong]

Did you drag the master dimension into the chart? 

[peterderrington]

Sorry, not quite sure what you mean.

Attached is an example of the chart.

Thanks

[Arthur_Fong]

Refer attached as reference.

[peterderrington]

So close....

we just seem to be missing the numbers for the week underneath - you can see the top of something that i'm presuming is the numbers.

[Arthur_Fong]

Where is the missing numbers? 

I can see the numbers of weeks are populated:

If you are referring to the Week Number label, refer attached.