Scatter Chart Axis Format Using a Calculation Group

[Anonymous]

Greetings Community,

I am trying to create a basic scatter plot: Volume in lbs. on the X-Axis and a selected measure on the Y-Axis.

The X-Axis format needs to be a whole number and the Y-Axis format needs to be in dollars to the second decimal place.

The reason I am using a calculation group is because I want to be able to slice by a selected measure and have only the Y-Axis value change - the X-Axis measure will always remain the same calculation which is Volume.

I have done all the proper format strings in the calculation groups however both the X and Y axis values are showing in dollars instead of dollars and whole number.

How do I get my scatter chart to format the X and Y axis correctly?

[Anonymous]

Hi @amitchandak 

Thank you for the response. Are you asking for the Calculation Group format string? If so, below is a screenshot of the format string for Volume (whole number) and one example of rate per pound. (dollar value)

Gross Sales rate per poundTotal sales volumeCalculation ItemsSELECTEDMEASURE

[amitchandak]

@Anonymous , is it possible to share the format code. to me seem like issue with formatting

[Anonymous]

Hi @amitchandak are the pictures I provided above what you were looking for?