Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 202300, 202301, 202302, 202303, etc.]
I tried switching to "Categorical", but the ordering of the x-axis got screwed up:
Lastly, in my .pbix file, I have a Dimension table specifically for the periods, but that does not seem to be helping with the ordering of the x-axis?:
Any help on getting the order correct on the x-axis would be greatly appreciated!
Solved! Go to Solution.
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!
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: https://www.youtube.com/@letssolveproblem
Regards
Thank you! This is also helpful...sorting the axis did the trick
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!
Omg - thank you!! I didn't even realize that option was contained within the 3 dots!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
101 | |
76 | |
64 | |
63 |
User | Count |
---|---|
141 | |
105 | |
101 | |
80 | |
66 |