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 Userjeseng
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
Helper IIIIn 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: