Stacked Column chart Y series comma separator

[Anonymous]

Hi all, 

a basic question that I cant figure out, 

I have aStacked column chart that y series shows valuse 1000000, 5000000, 10000000 etc but I want to appy 1000 comma separator, any advice how to do it .

thanks 

[themistoklis]

@Anonymous

Click on the measure that you are using on the Y axis.

Then go to Modelling Tab --> Format --> Click on the comma separator

[Anonymous]

T

the number appears on the leftside of the chart is auto generated?? I have tried to go to format panal Y serise and change the value to thausand but it only apply the K rather, the steps you have advised it wont be applicable becasuemeasure wont drive the numbers , measure would onlky drive the value inthe chart

[themistoklis]

@Anonymous

I tested on my own stacked chart and you should have the display units as None on the chart and also make sure that on modelling tab you made the measure comma separated (process described on the previous message).

[Anonymous]

Hey,

thanks for reply

I have set it as Non for Value dcimal places, but still not sure about the modeling anf format and comma separated as I cant see it on those level when selecting a test measure just to see,

[themistoklis]

@Anonymous

Im a bit confused now. Have you actually tried to change the format and click on the comma separator?

Any chance to share the workbook with us?

[Anonymous]

 I am not able to see/locate  "comma separator" under modeling >format

[themistoklis · Accepted solution]

See Image below. You need to click on the measure first on the FIELDS pane

[Anonymous]

Thanks, sorted 🙂