Forum Discussion

truch2's avatar
truch2
Frequent Visitor
9 years ago

To change how the axis is displayed, without changing the data column itself, try using groups. Select your graph. Under the "Axis" label should be your date column containing the values on your x-axis (02/01, 03/01, etc.). Click on the small grey down arrow and select "new group". Choose "Group Type" as "List". Now you can put your x-axis together anyway you see fit. Also, if you just want to change the names, put each item in a group by itself and rename the group as you see fit. Just be careful, sometimes powerbi will reorder the axis in a way that's unpleasant (text axis are especially vulnerable to this). Good luck!

  • jiinson's avatar
    jiinson
    Helper I
    9 years ago

    truch2Thanks for reply.

     

    I made a group but when I use groups as an axis I can't see 90 data points. 

     

    Best Regards,

    Jiin Son

    • truch2's avatar
      truch2
      Frequent Visitor
      9 years ago

      Perhaps I misunderstood what you watned to do. If you put every item in the same group, only one item will show on the axis. To change the title of an item, it needs to go into a group with only itself.

       

      However, I think what you want is to change the axis from "categorical" to "continuous".  Assuming that your column was imported as a number type, you should be able to do this easily. Click on the visual. Click on the Format options (the paint roller icon). Click on "x-axis" and make sure the "type" is set to "continuous".