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.
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...
Super UserHi 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.