Forum Discussion

music43's avatar
music43
Advocate 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 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

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


4 Replies

  • v-menakakota's avatar
    v-menakakota
    Community 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.

    • music43's avatar
      music43
      Advocate II
      1 year ago

      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's avatar
        v-menakakota
        Community Support
        1 year ago

        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.