I have plotted a bar chart. I have sorted the variable S. I want the bars of it to appear in the order of S1, S2 and S3. However, when plotted on the bar chart, it is not so. They are still in descending order. Can anyone help me With that?
Thanks in advance!
In your bar chart, right-click the axis heading FLYKE and then select Sort > Ascending.
Does this correct the issue?
When you say that you sorted Smilefjeskarater, did you perform that sort in your data preparation or did you create a custom sort in the report designer interface?
No, I want for each fylker, Smilefjeskarater is sorted and have fixed position on the axis.
I found that With slicer, when I make changes in slicer, the color of each Smilefjeskarater will change sometimes… how can I fixed the colors of the Smilefjeskarater so that they are not affected by slicer?
If you right-click the bar chart, you should see a menu like this:
The bottom pair of sort options in this menu selects the sorting for the group variable. If you specified a special sort order for the group variable, it should still work (but it will reverse the custom order if you select Descending.)
To permanently fix the colors, you could create display rules to specify the color for each value of your group variable. If you do this, then the colors should never change.
I'm glad you found some useful info @Yiting! If one @Sam_SAS's replies was the exact solution to your problem, can you "Accept it as a solution"? Or if one was particularly helpful, feel free to "Like" it. This will help other community members who may run into the same issue know what worked.
Join us for SAS Community Trivia
SAS Bowl XXIX, The SAS Hackathon
Wednesday, March 8, 2023, at 10 AM ET | #SASBowl
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.