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.
Hi All,
I'm transitioning from Tableau to PowerBI and I'm trying to compare two testing sessions (TermNames) by percentages at each quintile level (Low, LoAvg, Avg, HiAvg, High). It works fine in the bottom right Matrix table. But, I can only get the Count of Student ID to show in the clustered column chart. When I try to change the Y-axis from Count of Student ID to Show value as...it only gives me the option to use percent of grand total...not percent by TermName.
Any help would be greatly appreciated!
@Raudolph11 , You can create by creating a measure
divide(count(Table[Student ID]), calculate(count(Table[Student ID]), removefilters(Table[TermNames]) ))
or
divide(count(Table[Student ID]), calculate(count(Table[Student ID]), allselected(Table[TermNames]) ))
refer: https://www.youtube.com/watch?v=6jTildcV2ho
I'm not sure where to put the new measure in the clustered column chart. I tried putting it in the Y-axis, but it gives me 100% for each quintile.
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |