Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Can anyone explain why label density only shows as an option when there is a continuous x-axis? Labels reflect the value on the y-axis and I don't see why it should matter whether the x-axis is continuous or categorical. Thanks.
Solved! Go to Solution.
hi, @mbroderick
In a Line chart, Label Density feature is available when the X-axis display numbers or dates, and X-axis Type is set as Continuous.
The reason is that when the X-axis is Category type, there is a scroll bar for us to see each data point clearly by scrolling right or left. And if X-axis values are not numbers or dates, the axis is Category type by default. But if it's Continuous type, there is no scroll bar and don't have labels in X-axis for each data point. The Label Density is used in this scenario.
Best Regards,
Lin
This is something that my stakeholders also point as a flaw in Power BI. Since labels are something that always should show.
hi, @mbroderick
In a Line chart, Label Density feature is available when the X-axis display numbers or dates, and X-axis Type is set as Continuous.
The reason is that when the X-axis is Category type, there is a scroll bar for us to see each data point clearly by scrolling right or left. And if X-axis values are not numbers or dates, the axis is Category type by default. But if it's Continuous type, there is no scroll bar and don't have labels in X-axis for each data point. The Label Density is used in this scenario.
Best Regards,
Lin
Why is this not possible for the Y-axis?
Thanks for the developer reasoning, Lin.
But I still don't see why label density must necessarily be excluded from a non-continuous x-axis. I see that such an axis provides left/right scrolling and a continous one doesn't, but a non-continuous one then requires users to mouse over high and low values to see what they are instead of being able to see them at-a-glance as in a continous x-axis. The option for a non-continuous x-axis is then all or nothing. "All" creates a busy-looking chart, while "nothing" demands extra user interaction to see what might otherwise just show depending on the dashboard creator's choice of label density.
I did mark your answer as the solution, and I appreciate your response.
Above discussion is great for analysing against time
However, we need Density customisation for non-continuous X axis
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
99 | |
38 | |
37 |
User | Count |
---|---|
158 | |
125 | |
76 | |
74 | |
63 |