Forum Discussion
Bar/Cluster Chart with horizontal target area bar
Hi Community
I have a requirement to build a bar/cluster chart that displays quarterly data and a target range
Example visual (built in Excel using Combo Chart of Cluster and Stacked chart)
Data set is
Qtr Val Target Low Target Range
1Q20 1.48 1.6 0.2
1Q21 1.73 1.6 0.2
1Q22 1.76 1.6 0.2
2Q20 1.8 1.6 0.2
2Q21 1.73 1.6 0.2
3Q20 1.79 1.6 0.2
3Q21 1.79 1.6 0.2
4Q20 1.72 1.6 0.2
4Q21 1.81 1.6 0.2
Anybody any pointers on how to achieve this in PBI?
Cheers
Telstar
amitchandak - thanks for your suggestions/assitance on this.
After 'playing' about with the line and cluster column graph visual I got to an acceptable solutionThanks again
Cheers
Telstar
5 Replies
- amitchandak
Super User
Telstar , You have error bar features, that can help
refer
- Telstar
Helper I
Hi amitchandak
Thanks for the quick response
Unfortunately the error bar > error band analytic option is not available on a Clustered Bar visual :(, only on Line graphs as in the video you sharedCheers
Terry- amitchandak
Super User
- Telstar
Helper I
amitchandak - thanks for your suggestions/assitance on this.
After 'playing' about with the line and cluster column graph visual I got to an acceptable solutionThanks again
Cheers
Telstar