Forum Discussion
Helper ICusomize series not working reg,.
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!
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
6 Replies
- Greg_Deckler
Community Champion
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?
MeerakhannaHi!
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-msftMicrosoft Employee
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
