dynamic y axis with min value as 90% of the value.

[itsmeanuj]

Hi Guys,

Is there a way in Power BI where we can have a dynamic Y axis with a minimum value of 90% of the total value? this is to see the difference between the 2 bars clearly. I have placed the PBI file at the below link for reference. 

https://drive.google.com/file/d/1jjGDyPRG7xlDM6IR7KLNkOkRwHVZ0oSD/view?usp=sharing

Thanks,

Anuj

[Anonymous · Accepted solution]

Hi @itsmeanuj ,

What is the sum of your total values? You can calculate the total value using the following measure.

sum = SUMX(ALLSELECTED(Versions),'Versions'[Columns for which the total value needs to be calculated])*0.9

Under the "format your visual" pane, set the minimum y-axis value.

Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.