Power bi x axis skipping labels - jbcgf.autoricum.de Step-3: Now all three levels of hierarchies are visible in x-axis. Step-4: Now sort the chart data by year, quarter & month. click on ellipsis icon > Sort by > Year Quarter Month. Step-5: Make sure sort order should be ascending, again click on ellipsis icon > Sort ascending. Step-6: Now turn off concatenate labels- Go to format pane > X axis.