Forum Discussion
Up and Down Arrow on Target line
- 1 year ago
- 1 year ago
Thank you Fowmy,
Perfect! this is what I'm looking for. I checked the attached file.
It will be nice if you can explain what steps you have done. I'm still learning PowerBI and don't know how to do this.
I'll appreciate if you can guide the steps. Thank you.
- 1 year ago
jambopriti
This has a long series steps.
1. In a column chart, add target, apply conditional formating to color the column based on Actual vs Target.
2. Change chart type to line, and move the target to Seconday section, add survey x-axis
3. Select Survey Axis, remove, line and add error bars, please check the settings
4. Chagne the min and max values of both axis. 0 and 100 - 1 year ago
Thanks Fowmy.
I'm unable to follow your steps and can't replicate.
Thanks for your time. I'll select as a solution and hope it will help somebody. Thanks.
- Fowmy1 year ago
Super User
jambopriti
This has a long series steps.
1. In a column chart, add target, apply conditional formating to color the column based on Actual vs Target.
2. Change chart type to line, and move the target to Seconday section, add survey x-axis
3. Select Survey Axis, remove, line and add error bars, please check the settings
4. Chagne the min and max values of both axis. 0 and 100