Forum Discussion
timosborn
1 year agoFrequent Visitor
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 screen...
- 1 year ago
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 😉
SamWiseOwl
1 year agoSuper User
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)