<div>
What y-axis?<br />
You can use this expression for the value to calculate the percentage of the maximum value in the dataset:<br />

<pre><code id="code-20-40850088-1">=Fields!nr.Value/max(Fields!nr.Value,&quot;dset&quot;)</code></pre>
nr is the field name &quot;dset&quot; the name of the dataset. But you can also divide by 80000 to use that value as the 100% always. This will give you values from 0 to 1. Set the format of the y axis to Percentage to show this value as a percentage. You can set the minimum and maximum properties of the axis to 0 and 1 to always have 0 to 100% on the axis.
</div>


What y-axis?
You can use this expression for the value to calculate the percentage of the maximum value in the dataset:


=Fields!nr.Value/max(Fields!nr.Value,"dset")

nr is the field name "dset" the name of the dataset. But you can also divide by 80000 to use that value as the 100% always. This will give you values from 0 to 1. Set the format of the y axis to Percentage to show this value as a percentage. You can set the minimum and maximum properties of the axis to 0 and 1 to always have 0 to 100% on the axis.

<div>
Where do i put these expressions?
</div>


<div>
<div class="content wysiwyg-content">
I want to update this y axis so that it makes sense for my data ... probable 0 through 100% instead of 0 -&gt; 80000 as it is showing noe
</div>
</div>


I want to update this y axis so that it makes sense for my data ... probable 0 through 100% instead of 0 -> 80000 as it is showing noe

SSRS chart Y axis

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.