topic Re: "Same value" line values not aligning in Desktop

"Same value" line values not aligning

jgdgsf2 — Thu, 30 Jun 2022 11:00:22 GMT

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

Re: "Same value" line values not aligning

Seanan — Thu, 30 Jun 2022 11:06:05 GMT

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.

Re: "Same value" line values not aligning

jgdgsf2 — Fri, 01 Jul 2022 08:33:32 GMT

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.

Re: "Same value" line values not aligning

v-luwang-msft — Wed, 06 Jul 2022 07:51:00 GMT

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