Forum Discussion
Sorting axis with two variables
I rephrased / reposted my question, and was able to get an answer.
Solved: Re: How to rank / sort when you have two variables... - Microsoft Fabric Community
Hi sroemer26 ,
1. Place the fields you want to use in the table visual.
2. Hold down the shift key and select the two fields you want to sort on the x-axis.
3. Select this visual and change it to a clustered column chart.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Well, I tried that, but still no dice. Still May, April and March, and not from least to greatest. 🤔
Hi sroemer26 ,
1. Adjust the sorting of Month Name, Year columns so that they are sorted by month number or other ordered columns.
2. Make sure to put the right fields in the right places.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.