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.
Hi Datanauts,
I'm trying to show a line and clustered column chart sorted by month, which I tried to realize by plotting the months as "18_01", "18_02" etcetera. However, when I create the graph, this is the result:
It appears Power BI decides to sort the X-axis by largest samples. I tried to 'sort by column', but that was not the right move. Underneath is the Excel sheet I created for use in Power BI.
What is in your opinion the best / easiest way to make sure I show the same data, but sorted by month?
Thanks in advance,
Stefan Raets
Solved! Go to Solution.
Create a new column and extract the month only like(01..02..03) exclude the Year Part. Then Sort the Maand(i.e your column name) by New Column you have created(In Modelling Tab). This will fix your problem, if you still unable to fix the problem just share the pbix file with us we will fix that.
Create a new column and extract the month only like(01..02..03) exclude the Year Part. Then Sort the Maand(i.e your column name) by New Column you have created(In Modelling Tab). This will fix your problem, if you still unable to fix the problem just share the pbix file with us we will fix that.
Thanks kaushikd,
It did the trick!
Once you create the new column then follow this link
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 |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
146 | |
106 | |
104 | |
89 | |
65 |