Forum Discussion
Stevenrizado
8 years agoFrequent Visitor
Sorting X-axis in line and clustered column chart
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,...
- 8 years ago
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.
kaushikd
Resolver II
8 years agoCreate 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.
- kaushikd8 years ago
Resolver II
Once you create the new column then follow this link
- Stevenrizado8 years agoFrequent Visitor
Thanks kaushikd,
It did the trick!