How to adjust Y-Axis Minimum of Bar Chart automatically based on Minimum bar in chart

[Anonymous]

Hi,

I have a graph like this and next is the raw data.

But I don't want 0K to be my minimum, for example, I would like it to be 200K instead. 

Then now I want to look at the value of Product type A with the use of filter,

I want the minimum to be 60K instead.

So how could I set this formula so that minimum will be equal to 80% of the minimum shown in the graphs?

I have tried creating a measure = MINA(DATA[Value])* 80%, but it only returns the minimum value of a single project in my raw data, instead of the minimum value of total value of a month.

Is there a way to do that?

P.S. My actual report has more filters than this, not sure if it would affect the solution.

Thank you very much in advance

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create measures. 

sum of month = CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),MONTH('Table'[Period])=MONTH(MAX('Table'[Period]))))

min = MINX(SUMMARIZE(ALLSELECTED('Table'),'Table'[Period],"sum",[sum of month]),[sum])*0.8

(3) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

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.