Forum Discussion

Brent_Hel700's avatar
Brent_Hel700
Frequent Visitor
3 years ago

Line and Stacked Column Chart - Individual Data Label Control Not working in March 2023 PBI Desktop

Line and Stacked Column Chart - Individual Data Label control seems to have stopped working properly in the March 2023 version of PBI Desktop.

 

On a Line and Stacked Column Chart, when I got to Format->Data labels->Show data labels (On)->Apply settings to->Series dropdown (Individual Series-level control)

Then I select an individual Series (the Line) and turn Show data labels off, it turns off ALL of the data labes for all Series at the "Data Label" level, not just the one I selected in the series dropdown. (See image below):

6 Replies

  • PiEye's avatar
    PiEye
    Resolver II

    Hi Brent_Hel700 

     

    This is interesting, but I also have March 23 version and am not experiencing the same. I am able to control which series has labels, and even the colours of each

     

    I have the line and stacked column chart, the same as you.

    I did notice that if I have too many bars on screen, some of the labels stop showing. Does that affect you too?

     

    Pi

     

    • grantsamborn's avatar
      grantsamborn
      Solution Sage

      PiEye  Brent_Hel700 

      with your example, what would happen if you only want labels on the line?

      I ran into a similar problem when I wanted to select labels for the line but not categories OR subcategories of the columns, but when I wanted to select Line OR Column the only options were the various subcategories.

      I hope that makes sense.

       

      sample pbix: Contoso - test chart.pbix

       

       

      • PiEye's avatar
        PiEye
        Resolver II

        Hi Grantsamborn,

         

        Wow! Thank you for the example I see what you mean now. 

        So we can only make it work by going into every individual category and changing the option for each single one.

         

        I'm wondering why Microsoft took the decision to design it like that - I'm guessing they went for configurability. But it's not a very efficient way to do it, and what if the categories change??

         

        Workaround / solution....

         

        I have managed to find a workaround. Basically, I set the format to the bar measure [Sales] to format as "nothing"

         

        To do this, go into the data model, select the measure you need to remove and change to a custom format, which is blank

         

        This will remove the number from displaying in the chart.  NB the measure will also disappear from anything else you are using, so it is probably a good idea to duplicate it first:

         

         

        Pi

         

    • Brent_Hel700's avatar
      Brent_Hel700
      Frequent Visitor

      Yes. If I have to many categories to slice by they stop showing as well.

  • Anonymous's avatar
    Anonymous
    Not applicable

    I am running into this same issue. I would like to only show data labels for the line. The ability to disable the bars en masse not working in any manner I've tried. Seems very buggy.

  • September 2023 version still experiencing issues with data labels in 'Line and Stacked Column Chart'. If I turn off Data Labels it is automatically turned off. I can turn off data labels for either line or bars but turning off both turns both of them back on again.