Forum Discussion
Changing X-axis label density
Hi I am new to Power BI! I would like to ask if anyone know how to change the label density of X-axis. For example, I would like every year to be displayed here rather than being displayed in even number. Thanks for the help.
Hi zhk_yh2
You cannot change the x-axis label density by format settings .But you can add a slicer to skip the x-axis label for Q1-Q3 and only display Q4 ,like the screenshot below .
To achieve the above effect , you need to create a column to return the number of Quarterly and then use the column to add a slicer to filter data in Line chart .
qtr = QUARTER('Table'[Date])I have attached my pbix file , you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
zhk_yh2 Perhaps try changing the x-axis to Categorical instead of Continuous?
Hi zhk_yh2
You cannot change the x-axis label density by format settings .But you can add a slicer to skip the x-axis label for Q1-Q3 and only display Q4 ,like the screenshot below .
To achieve the above effect , you need to create a column to return the number of Quarterly and then use the column to add a slicer to filter data in Line chart .
qtr = QUARTER('Table'[Date])I have attached my pbix file , you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler Yeah it works! But is there any option to tune the x-axis label density here? Let say I want to skip the x-axis label for Q1-Q3.
zhk_yh2 You can play with the Minimum category width, that is the only setting I know for that but it doesn't really control density.
