How do I format a decimal in an SSRS chart?

SSAS and SSRS
1

The sql in thedataset produces numbers like 42.422825070100. Without modifying the sql query, is there a way to format a bar chart such that the number will be 41.42?

If I click on the numeric label, the properties window has an option to format. What should I put there

2

What data type is that value from source?

3

I figured it out through trial and error. The solution is to click on the actual number in the design and then in the properties window there is a setting for "Format". There, just type
#.###
for three digits after the decimal

1 Like