Quarter Year display in chart Lable

[Anonymous]

hi gurus,

if i select "Quarter year" it should display Q1,Q2,Q3,Q4  in chart lable

Source: Q1 14, Q2 14, Q3 14,Q4 14

output:  Q1,Q2,Q3,Q4...........

multiple selection display

using Get field selections

Thanks

[CELAMBARASAN · Accepted solution]

Try in chart title

=Concat(Left([Quarter Year], 2), ', ')

Thanks

[Anonymous]

Hi Alex,

Hi Thanks for your Time subfield with getfield selections not displaying multiple selections in chart window

[alex_millan]

Hi again,

If you don't need the second part of your values ( ' 14'), why don't you simply dismiss it on the script?

Use the same command on the script when loading the values, for example:

LOAD Subfield([Quart yer],' ',1) As [Quart yer], Sales;

LOAD [Quart yer],  Sales FROM [Quarter year.xlsx](ooxml, embedded labels, table is Sheet1);

Perhaps that simplifies the problem.

Good luck 😉