Y axis value change based on the target value

[Anonymous]

 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 · Accepted solution]

@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.

[Syndicate_Admin]

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.