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 @josephsoto,
Looking at your x axis, since you have a value for "51B" the column you are using is not numeric and therefore Power BI is not sorting in numerical order. My recommendation is to create an additional table which has a column for the values in your x axis and then a column for the order you would like to impose. Example:
Value | Order |
51B | 2 |
50 | 0 |
51 | 1 |
Once you have this, you can create a relationship between this new data source and the data source containing your x axis. You'll need to add a new custom column to the orignal data source you can use the related function in DAX to bring the order over from the new data source. From here, it's simply a need to sort one column (the one containing your x axis values) by another (the order column you brought in from the new data source).
Both hyperlinks contain additional documention directly from Microsoft. I hope you find this helpful!
Hi,
Thanks for your efforts to help.
I was able to fix it by sorting the axis.
Hello @josephsoto,
Looking at your x axis, since you have a value for "51B" the column you are using is not numeric and therefore Power BI is not sorting in numerical order. My recommendation is to create an additional table which has a column for the values in your x axis and then a column for the order you would like to impose. Example:
Value | Order |
51B | 2 |
50 | 0 |
51 | 1 |
Once you have this, you can create a relationship between this new data source and the data source containing your x axis. You'll need to add a new custom column to the orignal data source you can use the related function in DAX to bring the order over from the new data source. From here, it's simply a need to sort one column (the one containing your x axis values) by another (the order column you brought in from the new data source).
Both hyperlinks contain additional documention directly from Microsoft. I hope you find this helpful!
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.