10-31-2016 09:16 AM
I have a report where I have displayed multiple measures on a bar chart. These are all in the millions and so the report axes displays $1,000,000, $2,000,000 etc. However it would appear much cleaner to display this as $1M, $2M etc. Is this possible within SAS Visual Analytics?
Interestingly when I selct to show the Y axes label, the values display as $1, $2 etc, however this isn't satisfactory as it doesn't show that these are millions, plus the axes label display all 5 of the measure names which is rather ugly.
11-08-2016 04:28 AM
What you want to achieve can only be done through user-defined formats.
The following note covers the information about user-defined formats in SAS® Visual Analytics:
Have a good day
11-08-2016 02:17 PM
Just be aware that the usual way of doing this with a user-defined format would be with a PICTURE statement. PICTURE formats are explicitly not supported in the current release of SAS VA. This is unfortunate as they would add a lot of flexibility to the way data can be displayed. I live in hope that they may be supported in a future release...