Forum Discussion

music43's avatar
music43
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Column Chart phantom bar & data label issue

Hi, Experts I have added a column chart, enabled data labels and disabled responsive (but have tried on and off). The chart has a visual level filter on the x-axis to remove blank. My quest...
Need Help
  • music43's avatar
    music43
    1 year ago

    Hi v-menakakota 

    Thank you for your input.

     

    I thought I'd post the answer, which I just found yesterday.

    The setting under Data Labels > Options > Label Density was set to 50%. Adjusting it to 100% forces all the labels to show (where the column height is appropriate).


v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
1 year ago

Hi music43 ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

The extra bar on the left (sometimes called a "phantom" bar) could be caused by a hidden value like a blank, a zero, or even a space character that doesn't show up in the table view. Power BI can still treat these as valid categories on the X-axis.

Please try these steps once:

  • Add a filter to include only values greater than or equal to 1 on the "Invoice Day of Month" field.

  • Double-check that the field is stored as a number and not as text.

  • If possible, recreate the chart to see if it's just a visual glitch.

    If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.