Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

X axis formatting.

Hi All,
Can we show x axis like this in power bi :-

Instead of this

I have checked the x axis properties but didn't find relevant option to change the x axis like above image.

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous . I doubt we have much control on display. Just try concatenate label off. I doubt that will help much

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    According to my test, the x-axis of the chart in Power BI can only show up to 4 rows of values. 

     

     

    So it is recommended that you use a horizontal bar chart.

     

     


    Or show it in the tooltip. And you need to add a custom column in the Power Query.

     

    Custom = Text.Combine( Text.ToList([X]), Character.FromNumber(10) )

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi v-kkf-msft , thanks for your reply, my requirement is to create a line chart with this x axis as below image.
      Thanks for your suggestion but we can’t create a bar and column chart and can’t show series in a tooltip.




      And there are no error, I just want to format x axis like this if possible.