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 IIIThank you for your response.
I find that chatGPT have helped me many times with very good solutions in the past. Lately I've just find that it talks about layout-settings that I dont have in my version. Maybe the examaple above was a bad one, I have two other ones:
Bar chart: I would like to show only every other label; 0-4 years, 10-14 yeras etc. ChatGPT means that there should be settings for "label density settings".
Line chart: I would like to show the years 2000, 2010, 2020. ChatGPT again refers to settings in the layout of the x axis, that I dont have.
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
- jeseng
I 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.
- Ritaf1983
jeseng
This is exactly the issue I explained...
You need to create a bins in the data table.
You can refer to the linked video to get more detailed explanation.https://www.youtube.com/watch?v=9j_EBt3RNrs
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- jeseng
In my bar chart the labels are not numeric, I was under the impression that you can only use bin for numeric values? This is my data, very simple. What I want is to show ALL the bars but only every other label.
If i make list of "every other" label and use that in my bar chart it looks like this: