Forum Discussion

jgdgsf2's avatar
jgdgsf2
Frequent Visitor
4 years ago
Solved

"Same value" line values not aligning

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

Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    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

3 Replies

  • Seanan's avatar
    Seanan
    Solution Supplier
    4 years ago

    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's avatar
      jgdgsf2
      Frequent Visitor
      4 years ago

      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.

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    4 years ago

    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