cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mbroderick
Frequent Visitor

Label density and continuous x-axis

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.

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
Power BI Show Ep 4 Post Show Carousel.jpg

The Power BI Community Show

Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.

PBI April Release 2022 768x460.png

Check it out!

Click here to read more about the April 2022 updates!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!