Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

X axis formatting.

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

Yagevendra_0-1647867672759.png

Instead of this

Yagevendra_1-1647867701892.png

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

3 REPLIES 3
v-kkf-msft
Community Support
Community Support

Hi @Anonymous ,

 

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

 

vkkfmsft_1-1648100459411.png

 

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

 

vkkfmsft_3-1648100945137.png

 


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) )

vkkfmsft_0-1648100397030.png

vkkfmsft_2-1648100824219.png

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
Not applicable

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.




Yagevendra_0-1648101738404.png

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

amitchandak
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.