Forum Discussion

APodmoskovnov's avatar
APodmoskovnov
New Member
10 years ago
Solved

Data Labels

Hi, all   The problem is, every time I try to build combined column and line chart, I've got this mess with data labels. The system doesn't allow me to hide trend labels, leaving column ones only, ...
Need Help
Show and Tell
  • Habib's avatar
    Habib
    10 years ago

    Hi

     

    In latest version of Power BI Version: 2.36.4434.381 64-bit (June 2016), a new option for line data labels has been introduced with name Label Density. This way you can reduce the number of occurances of data label printing and will be help out in your case.

     

    refer to below image

     

Nhallquist's avatar
Nhallquist
Icon for Helper V rankHelper V
10 years ago

Well, you don't have a ton of options, but you do have a few.  One recommendation would be to put each expression on its' own axis, creating a dual axis chart.  Then, you can create a custom scale where you could make it disparate enough to have some offset between the line and bars.  Settings might look like the pic below, with the "Show s..." is actually "Show Secondary Axis".

 

 

Maybe you could share with us what the chart is being used for, and then we could suggest some alternative design ideas.

 

Nate

  • APodmoskovnov's avatar
    APodmoskovnov
    New Member
    10 years ago

    Thanks for your reply.

     

    I followed the instructions given here 

    https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-combo-chart-merge-visualizations/#create-a-combo-chart-with-two-axes

     

    But there's still a bunch of issues...

    1) Both data sets in my chart contain percentage values, I guess that's why BI doesn't add the second axis.

    2) Moreover, even if I drag another type of data (e.g. volume of sales) to the Line Values Bucket, BI shows the secondary axis, but doesn't suggest possibilities to adjust it. I am only able to show or hide both axes simultaneously and adjust the scale of the left (percentage) axis.

    Probably BI version issues? (I don't attach screenshot since I work with Russian interface)

     

    My goal is to create weekly chart with the company's market share in columns and moving average in the line above.

     

     

     

     

    • Nhallquist's avatar
      Nhallquist
      Icon for Helper V rankHelper V
      10 years ago

      One of the things I have to keep reminding myself is that Power BI is still very new, when compared to other tools.  With that, it doesn't always have what we want.  Have you looked at all at the Custom Visualization (Link).  There are quite a few new and different visuals that might better meet your needs.

      • Habib's avatar
        Habib
        Icon for Continued Contributor rankContinued Contributor
        10 years ago

        Hi

         

        In latest version of Power BI Version: 2.36.4434.381 64-bit (June 2016), a new option for line data labels has been introduced with name Label Density. This way you can reduce the number of occurances of data label printing and will be help out in your case.

         

        refer to below image