Forum Discussion

rmcgrath's avatar
rmcgrath
Icon for Advocate III rankAdvocate III
2 years ago
Solved

Trouble with X-axis

Hello.  My company reports a lot of financials in monthly periods, using the format "202301" (for January 2023).  As I plot those on the X-axis, Power BI increments the periods: [I wanted it to show ...
Need Help
Show and Tell
  • samratpbi's avatar
    samratpbi
    2 years ago

    Hi,

    can you try to sort your x-axis?

    If you click your visual, at top right of the visual, 3 dots appear.

    If this resolves your problem, then please mark it as solution, Thanks!

qqqqqwwwweeerrr's avatar
qqqqqwwwweeerrr
Icon for Solution Sage rankSolution Sage
2 years ago

Hi rmcgrath 

 

You can check this video where you can sort by column: https://youtu.be/PUaFtLpIMvY

 

Here first you need to create new table with respect to you period and assign the required order and it will be shorted. 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

rmcgrath's avatar
rmcgrath
Icon for Advocate III rankAdvocate III
2 years ago

Thank you!  This is also helpful...sorting the axis did the trick