Forum Discussion
Y axis value change based on the target value
i have line and column chart. line value starting 300 and 800 range. i want to set target value based on the selection
set start point not “0”, but = Target minus 5%, to make difference visible as much as possible
any idea ? y axis value change based on the target value ?
Anonymous
You can create a measure based on the current Y axis field value, e.,g. Measure = [Value] * 0.95.Then add the [value] and measure to the chart. If you currently using a measure as the value, then the new measure can be: Measure = Sum([Value]) * 0.95.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
2 Replies
Syndicate_AdminAdministrator
with the latest updates to Power BI Desktop you can apply formulas to the start and end of the y-axis.
create the measure that allows you to define the range of axis values and define it in the axis configuration options.
Anonymous
You can create a measure based on the current Y axis field value, e.,g. Measure = [Value] * 0.95.Then add the [value] and measure to the chart. If you currently using a measure as the value, then the new measure can be: Measure = Sum([Value]) * 0.95.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.