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.
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.
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!
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 👍
Proud to be a Super User! | |
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 |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |