SSRS Vertical bar chart , X axis label repeating after setting the category expression?

Question

SSRS Vertical bar chart , X axis label repeating after setting the category expression?

Repeating x axis label.Repeat x axis label

Repeat x axis label

Answer 1

I would sort the dataset by the live value if this does not do the trick then use case when to populate your x axis labels within your sql query.