Forum Discussion

quickbi's avatar
quickbi
Icon for Helper II rankHelper II
2 years ago
Solved

X Axis labels not shown

Hi I'm presenting Revenues per week chart. But the problem is not all the weeks labels are shown. The graph is huge is from side to side from the screen. Labels font size are 8px, and I dont know why not all labels are shown.

 

Anyone had the same problem?

 

Thanks in advance 

 

Eduard

  • Hi quickbi , yes you have to sort it by week number.
    Just click on three dots on visual n sort  axis by week number , ascending.


    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

8 Replies

  • manvishah17's avatar
    manvishah17
    Icon for Solution Supplier rankSolution Supplier

    Hey quickbi , 
    Can you please share sample pbix file or your sample data so I can try it by myself ?

    • quickbi's avatar
      quickbi
      Icon for Helper II rankHelper II

      Sorry Icloud not, the data model is huge and confidencial

  • manvishah17's avatar
    manvishah17
    Icon for Solution Supplier rankSolution Supplier

    Okay no problem. can you please just tell the measure and column you plotted??

     

    • quickbi's avatar
      quickbi
      Icon for Helper II rankHelper II

      Yes, for sure:

      In X axis are week number in int format. and in Y are the Revenues sum

       

    • manvishah17's avatar
      manvishah17
      Icon for Solution Supplier rankSolution Supplier

      Hi quickbi , 
      I created a sample file and faced the same issue but I got way to resolve it , 
      Select your bar graph -> FORMAT VISUAL -> SELECT X AXIS AND CHANGE TYPE TO CATEGORICAL 

       

       If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
      If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

      • quickbi's avatar
        quickbi
        Icon for Helper II rankHelper II

        Yes I founded before but when you did a categorical, the week order is not the same