Forum Discussion

soderqvistn's avatar
soderqvistn
Icon for Helper I rankHelper I
6 years ago
Solved

Better X-axis look?

Hi,   I am currently redoing stuff from Excel and PowerPivot to PowerBI and I like the look of Excel charts X-axis more. I tihnk it gets clearer vid 2 screenshots. See below. So in Excel the X axis...
Need Help
  • ibarrau's avatar
    ibarrau
    6 years ago

    Well, it is as I just mention before. Check this step by step gif adding year, quarter and the quantity.

     

    xcategorical concatenate

     

    Hope this helps,

     

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
6 years ago

Hi there. If you have your X-Axis as type "Categorial", then you can do this. Search for the option under X-Axis like this one and disable it.

Concatenate axis

The concatenate labels are the reason of this.

 

Regards,

 

  • soderqvistn's avatar
    soderqvistn
    Icon for Helper I rankHelper I
    6 years ago

    Hi I tryed changing it to Categorical and disable the concatination but I get the same result unfortunately.

     

    Problem is whenever I look at % it sums the values for years and that is obviously incorrect. Anyone else got an idea?

     

     

    • ibarrau's avatar
      ibarrau
      Icon for Super User rankSuper User
      6 years ago

      Be sure to be adding on the axis the year first and then the quarter. After that "expand the next level" with this button.

       

      Expand level

       

      Hope this works.

       

      • soderqvistn's avatar
        soderqvistn
        Icon for Helper I rankHelper I
        6 years ago

        Yes thats it! How did you get this to work?

         

        These are my current setting and it still doesnt work.