SSRS column chart hide labels on x-axis conditionally

0
votes

How to hide SSRS x-axis conditionally on column chart. If values are zero i dont want to display the label on x-axis. data values - x-axis shows category group -filing types values - filing count

Please check the below image

enter image description here

1
reporting-services

1 Answers

0
votes

Perhaps using the label format property. I know that you can set the Number format to Custom and do something like:

=IIF(Fields!HasPrefix.Value,Fields!Prefix.Value," #0","No Prefix #0")

(This is the ChartAxis.LabelsFormat property if you have the axis selected. If you bring up the "Chart Axis Dialog" then this can be found on the Number listview item's format field.

I bet there is a way to use a format specifier to make it null or ""