Graph scale problem

[mekaelj]

Hi,

I'm trying to show the percentage of discounts for my customers in a graph. I've calculated the discounts in the following way:

Discount percentage = DIVIDE([Sum of Discounts];[Sum of Revenue])

On the other axis I have the Revenue which and this is then sorted by customer.

When I put all this in a graph I get the following: 

Now I'm wondering why it's scaled like this and how I can get it to scale normally so the graph actually says something?

Cheers,

Mikael

[v-shex-msft]

HI @mekaelj,

Did these measures contains any specific filters?

If you can please share us more detail contents, it will be help for troubleshooting.(e.g. measure formula, table relationship, screeshots, other filter settings...)

In addition, you can also try to modify Y axis unit size at format tab.

Regards,

Xiaoxin Sheng

[Phil_Seamark · Accepted solution]

Hi @mekaelj

Maybe try and set the start/end of the y-axis to values that make sense.  Perhaps set the end value to 100?