Forum Discussion

zhk_yh2's avatar
zhk_yh2
New Member
5 years ago
Solved

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 n...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.