Cusomize series not working reg,.

[Meerakhanna]

Hi, I am creating a column chart with 3 series. three series are of different units. I saw 'Customize series' option as like below and tried to set different units for each series. But, it seems that is not effective. Any clue? if its a product bug? or Am I missing something? Please clarify. Thank you!

[Greg_Deckler]

It is working for me on Version: 2.38.4491.282 64-bit (August 2016).

If I expand my column series like ID in your case, I can set the data labels to not display, change their color, change the display format, etc.

Is there a particular thing that you are trying to set that you are having trouble with?

[Meerakhanna]

Hi!

ok. I have 3 value fields. 1 of just count of Ids. next 2 are of costs values.

I am trying to show up the data label for the 1st one to be of Number, next 2 to be of $M.

When i choose 'Display Units' for the $ value fields to be of millions, its just remaining as numbers but not as $M values.

PLease let me know if you don't get my xplanation.- thank you!

[v-micsh-msft]

Hi Meerakhanna,

The display units work at my side:

Please verify the Decimal Places, input the value with 1, or the number that you would like it to display. It should have the M at the end of the number, generally it would keep lots of Decimal Places.

See if this would help.

If any further help needed, please post back.

Regards

[Meerakhanna]

Hi Michael,

But it still not working for me, see to the below. the first column should be of Int, next should be of amount value which i want to show in K. Where am I going wrong? Could you please help me? - Thank you!

[v-micsh-msft · Accepted solution]

Hi Meerakhanna,

Well this seems to be a little wired.

How about editing the format part with only one of the three columns? I mean only add one of them, check if the visual format would work normally. If it works, then this should be related with the data difference between those three columns, you might consider to seperate them into different visuals.

Regards

[Meerakhanna]

Hi Michael!

Thanks for your reply.

Yes, i checked the data format. And after changing the data format for that field it worked fine. Thank you!