Forum Discussion
Error bars not working
It appears that the error bars in PBID & PBIS for the line chartare not functioning as they used to anymore.
Does anyone else get this?
I posted a visual on my Novy pro account, here is a screenshot of the error bars from a few months ago.
Here’s the same visual as it appears now with no changes made.
In PBI Desktop for the same report, I can’t get the error bars back when I click bar to on, nothing happens.
Has anyone else noticed this? Is there any workaround or way to get them working that anyone has noticed?
My Novy pro account, notice the difference between the screen shot and the live visual
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 😉
4 Replies
Hi timosborn
You could force it to appear by setting the upper limit to be your base calculation:
Probably want something like:
Upper Measure = If( [measure] > 0, [measure], 0)Lower Measure = If( [measure] <= 0, [measure], 0)
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 😉
amazing, thanks Sam!
