reporting services - SSRS 2008: how to change chart axis unit dynamically? -

I have a chart in the SSR report and it shows the total revenue from its Wi-Ax salesman. The unit is "million" for Y Axis and it works perfect for the total amount.

However, there are thousands of salesmen and when one vendor is selected in the parameter panel, the amount of sales can be at "hundred" level. Thus, it will be very small to identify the bar on the chart

Is there any way to dynamically change the Wi-Ax unit during the running time?

As you have seen, in the chart designer you show value , but you It can not be expression-based:

However, if you see Properties for Axis Asterisk , then you can do this as an asset label format which is expression-based:

So when you select millions in the chart designer, the format expression will look something:

  0 ,,, (0,)   
 And something like thousands will appear:  
  0; (0,)   
 Based on this, you can create Expression-based  Label Format  keeping in mind the data:  
  = IIf (Max (Field! Total sealed valve)> 100000, "0,; (0,)", "0,; (0,)")   
 Accordingly There is probably anything to update  axis title :  
  = IIf (max (field! Total sals.value)> 100000, "sales ( Consider a simple dataset and chart:  
   
   
 Axis updates appropriately on the basis of the underlying data:  
   
   
 You will need to explicitly adapt to your particular data but hopefully it will tell you in the right direction.