Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |