October 29, 2015 at 10:12 am
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")
October 29, 2015 at 2:39 pm
Except Percentage(%) label 2 are working fine. I'm getting 15,000 but i want 150
I used given below formula
=Switch(Parameters!MeasureMDX.Label = "Weekly Count",Int(150),
Parameters!MeasureMDX.Label = "Weekly Sal","$150",
Parameters!MeasureMDX.Label = "Floor Hours %",Format(0, "P"),
Parameters!MeasureMDX.Label = "Sat/Sun Waiting > 15 Min %",Format(0, "P"),
Parameters!MeasureMDX.Label = "Wait Time ",Format(0, "P"))
Please let me know if anyone has any idea!!!
October 29, 2015 at 9:50 pm
From my understanding the percentage format will automatically add in a *100 to the data.
Check to see if you are doing this in your expression or code and if so remove it.
Should work ok after that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply