Forum Discussion
Error bars not working
Hi timosborn
edit 3 Service Profit Analysis.pbix
You could use the Margin for the visual and the upper error and zero for lower.
Use a measure to then colour the measures >0 blue, less red
Or have the margin and the other two in to generate the line.
The sneaky trick is turning the chart into a column chart, applying the measure to the columns formatting, then turn it back to a line chart 😉
HI Sam,
Thanks so much for the response.
I tried your method but I just can't seem to get it working.
I already have measures as you've mentioned. The only way I can now get the bars to appear is if I put symmetrical or relative on, but then they go all weird.
Can you please share your main report measure and error bar settings?
I've attached my report, it has demo data so no issue with sharing.
https://drive.google.com/file/d/1iqiocLB6FVWupmJXcLJQoG3ucyR6ZCjc/view?usp=sharing
Hi timosborn
edit 3 Service Profit Analysis.pbix
You could use the Margin for the visual and the upper error and zero for lower.
Use a measure to then colour the measures >0 blue, less red
Or have the margin and the other two in to generate the line.
The sneaky trick is turning the chart into a column chart, applying the measure to the columns formatting, then turn it back to a line chart 😉