Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |