Forum Discussion
Anonymous
6 years agoNot applicable
Clustered Bar chart with individual reference line
Hello, I've been trying to create a clustered bar chart with a reference line for each column bar, something like the image below. Does anybody knows if it is possible? The reference line is the va...
v-yingjl
Community Support
6 years agoHi Anonymous ,
You can try to use the Analysis pane to set the reference line in power bi desktop.
Please refer this document:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
If the line value is one of the previous month value, you can write a measure to calculate it and use this measure as the reference line.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
6 years agoNot applicable
Hello Yingjie thanks for your reply, unfortunetadly, this option only allows for a single reference line accross all the graph, which is not the requirement.
Regards