Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to Solution.
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
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
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.
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.
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
Hey Habib, I don't have this propiety (Label Density), in my Power BI Desktop (current using 2.108.997.0 64-bit (August 2022)).
Any other ideas on how to fix it? I'm having the same issue with a "Line and Stacked column" chart.
Thanks Habib, works a treat. +1
Hi Habib,
I updated my power bi desktop version today but i could not find the "Label Density " , can you please help ?
Thanks
Sajid Hussain
How can You Change Colors for Data Labels , Line & Custom Colored chart shows 2 different data lables how can i have different colors for data lables ????
Color option is avaiable under "Data Labels" option in latest version of Power BI.
The "data Lables" show just one color option for the entire chart (say if the chart is a combo chart with line and bar graphs), is there a way to change the lables into different colors according to the different line and bar graph on a perticular chart ?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
124 | |
107 | |
60 | |
55 |