Forum Discussion
Horizontal Bullet Bar Chart with label display
Why when Actual<0, value can't display in chart
1.source data
2.when selected all category,Target can display
3. when selected one category,,actual>0, Target can display
4. when selected one category,,actual<0, Target can't display
6 Replies
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/14475231.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?
