Forum Discussion
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, though this option is available in simple line charts.
Do you have any ideas?
Thanks is advance.
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
14 Replies
Hi Microsoft, this is a very basic end-user feature.
Currently, the hability to change the data label density its only available for pure line charts. If we are using a combo chart this option is not available. We need the option for managing the labels per each data field - eaither column or line - having the possibility to change colours, sizes, hide/show independently.
Please add this basic design feature in the May 2018 release.
Thanks
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
Thanks for your reply.
I followed the instructions given here
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.
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.
The ability to hide line data values is still not an option? I'm using it as a dynamic target that changes as different items are reviewed and I have a clutter of redundant values on a straight line.
I have the exact same problem. Come on Microsoft!
I need the option to hide the line values and only show the column values too. The line value is only a straight line anyway since it's a target but needs to remain dynamic since I can change the item being reviewed thus the target changes. It would be nice to be able to hide the line values that are all the same just causing clutter and redundancy.
