Column Chart phantom bar & data label issue

[music43]

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 question, why is there a phantom bar on the left and why don't all of the data labels show. Clearly there is room for them. When viewed as a table, there is no other value that could explain the gap on the left.

Also, padding is set to zero.

Thanks for any advice of suggestions 👍

Oli

[v-menakakota]

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.

[music43]

Hi @v-menakakota 

Thank you for coming back to me with these suggestions. Playing around with a new chart I discovered a couple of thing. The invoice day of month field is stored as a number. 

Trying to filter where the value is greater than zero and is not blank doesn't work

Changing the type from continuous to categorical forces the phantom bar to show as a blank, and fltering is not blank works

Interestingly, when the axis is correctly set to continuous again, forcing the axis to start at 1 works. This seems a bit buggy, right?

Finally, did you happen to have any suggestion on how to get all the data labels to show - other than widening the visual (as this isn't an option being a tooltip page visual and would be too large).

Thanks again 
Oli

[v-menakakota]

Hi @music43 ,

Reduce the font size in the Data Labels settings to fit more labels without needing to widen the visual.

Position the labels inside the bars rather than outside or at the end to make better use of the available space. Once try to change these.

Thank you and Regards,
Menaka Kota.

[music43 · Accepted solution]

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).