Customize Y axis data interval

[PBIDEV_10]

Hello Gurus

I have a graph where I show number of members per month. As you can see the change in the values is small and in the graph it shows like it has not change. Can I change the data range so that the graph shows the small increase?

Regards

PP

[Anonymous]

Hi @PBIDEV_10,

AFAIK, current power bi seems not have a feature to auto-resize the axis ranges to fit your data bars.

For this scenario, I think you can refer to amitchandak 's point of view to changing the start/end range of the axis to help recognize the small difference between these values.

Customize X-axis and Y-axis properties - Power BI | Microsoft Docs
Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@PBIDEV_10 , from Aug 2021, release you can use measure in the start and end value of the axis. Create measure and use those

Start Value  = minx(values(Table[Month]), [Measure]) -1

end Value  = maxx(values(Table[Month]), [Measure]) +1

Use these in fx of start and end