"Same value" line values not aligning

[jgdgsf2]

Hi everyone,

I have a couple of simple visuals that show how many people have left, in which month, and how many weeks they worked on average before they left.

My issue is, when I change my Weeks Worked to show as an average in the visualisation panel, my average values aren't algining:

As you can see, the "1" in the first graph aren't aligned - the second is slightly lower; same with the "7" in the second graph. This is because the average line is deviating because of the decimals:

I want the "1.1" and "0.9" on the first graph to show as "1" and the line to be flat. Same on the second graph - I want the "7.1" and "6.8" to show as "7" and be a flat line.

I have tried changing the data type to whole numbers and fiddled with the axis but I can't get the average line to round to the nearest 0. 

Any help would be greatly appreciated!

Thanks

[v-luwang-msft · Accepted solution]

Hi @jgdgsf2 ,

Pls add round on the base measure.

 ROUND(MAX('Table'[value]),0)

 Refer the below :

base data:

measure1:(then same question as yours)

t1 = MAX('Table'[value])

Then create visual:

measure2:

t2 = ROUND(MAX('Table'[value]),0)

visual:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Seanan]

Hi @jgdgsf2 

For your avg weeks worked measure could you see if there are decimal places shown for the values. If there are try changing it to 0

Kind regards,
Seanan
If this post helped, please consider accepting it as the solution.

[jgdgsf2]

Yep there are definitely no decimals and I have the data type set to whole number - no matter what I try the line deviates slightly.