Format Label Issue of Axis Property in SSRS

• poojamalik5814

  SSC Enthusiast

  Points: 141

  More actions

  October 29, 2015 at 9:33 am

  #322215

  How to change 3 format labels (Percent(%), Integer(Int) or Currency($)) based on Parameter Label in a vertical Axis Chart in SSRS.

  I applied this switch statement on Axis Option Interval in Axis Property in Chart but it doesn't work.

  =Switch(Parameters!MeasureMDX.label= "Weekly Count",Int(150),

  Parameters!MeasureMDX.label = "Weekly Sal","$150",

  Parameters!MeasureMDX.label = "Floor Hours %","%150",

  Parameters!MeasureMDX.label= "Sat/Sun Waiting > 15 Min %","%150",

  Parameters!MeasureMDX.label = "Wait Time","%150")