Change position of bars on bar chart

[bmcminn]

I have a table with an Admission Status column, for applications being Submitted, Enrolled, Confirmed, or Admit. I used a filter measure (Count Admits = CALCULATE(COUNTA('Append1'[Admissions Status]),'Append1'[Admissions Status] IN { "Admit" })) to get counts of each value. There is another column with Year (2022 and 2023).

I have a clustered column chart with each count in the Y-axis and year in the X-axis. Instead of having each year in it's own group, I would like the values grouped together, i.e. Enrolled 2022 and 2023 together instead of all of 2022 and all of 2023.

How would I accomplish this 

instead of this ? 

Thank you.

[Dhairya]

Hey @bmcminn 
You can just interchange fields in legends and x-axis to achieve your desired output!
here i have used dummy data to make it easier to understand.

Please mark my solution as accepted if it helped you!

[Idrissshatila]

Hello @bmcminn ,

Then what you could do is the put the year field in the legend and the admission status in the x-axis.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin