Forum Discussion
Horizontal Bullet Bar Chart with label display
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
1.source data
| Category | Actual | LY_Actual | Target |
| A1 | 1000 | 1010 | 1010 |
A2 | 1020 | 1000 | 1000 |
| A3 | 1040 | 1030 | 1030 |
| A4 | 1060 | 1070 | 1070 |
| A5 | 1050 | 1055 | 1055 |
| A6 | 1010 | 1020 | 1020 |
| A7 | 1055 | 1080 | 1080 |
| A8 | 1090 | 1010 | 1010 |
| A9 | -1200 | 1000 | 1200 |
| A10 | -1100 | -1000 | 1100 |
| A11 | -1300 | 0 | 1300 |
2.Display
When selecting category=A10, the target value does not display.
I found this occurs only when both actual and LY_Actual are negative, and Actual absolute values exceed LY_Actual.
3.expected output
When selecting category=A10, the target value can display in chart.
seems to work ok?
LY_Actual as Back Bar Values, Actual as Font Bar Values,and Target as second Label values.
When selecting a single category,and both actual and LY_Actual are negative, and Actual absolute values exceed LY_Actual, the target label fail to display.
expected outcome:
The target of A10=1100 is displayed at the end of the graph, just like the target of A8=1010.
Hi,
I reviewed the file you provided and made two changes.
1.The visualizations I use is Horizontal Bullet Chart with label.
2.LY_Actual as Back Bar Values, Actual as Font Bar Values,and Target as second Label values
Have you contacted the author of that bullet chart visual?