Forum Discussion
Helper IIIMissing option "Layout"?
Hi jeseng
Unfortunately, there's no built-in option to selectively modify which axis labels are shown. If the bar is present, the label will also be displayed—except in cases where there isn't enough space, in which the engine automatically hides some labels, especially on a categorical axis.
However, there is a workaround using data labels and conditional formatting to achieve a similar effect. The final result will look like this:
Note: This solution is only applicable to column charts, not line charts.
I've attached a PBIX file for reference. If needed, I can record a screen tutorial on how to implement it.
Super UserHi jeseng
This is again not a layout issue...If you want to show only a part of a group of ages , you should filter out the unwanted ones.
If you want to show bigger bins of years you should have a column in your data table which groups these years and use it on the graph.
Again a box is attached.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Helper IIII apologize, English is not my first language and I fail to explain what I am looking for. I have marked in red what I had hoped to achieve.
When I give chatGPT all the details in my data (which is very simple) and explain what I want to do this is it's response:
"1. Select your line chart in Power BI.
2. Go to the Visualization panel on the right.
3. Under X-axis, look for the setting for Max Labels or Label Density."
So at some point there should be a setting for the maximum number of labels, for a line chart, I thought...
- Ritaf1983
Hi jeseng
Unfortunately, there's no built-in option to selectively modify which axis labels are shown. If the bar is present, the label will also be displayed—except in cases where there isn't enough space, in which the engine automatically hides some labels, especially on a categorical axis.
However, there is a workaround using data labels and conditional formatting to achieve a similar effect. The final result will look like this:
Note: This solution is only applicable to column charts, not line charts.
I've attached a PBIX file for reference. If needed, I can record a screen tutorial on how to implement it.