Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table that I am reporting on that includes a column IsEmployed. The chart shows those employed (green) and not employed (red) for each year.
I would like to display a percentage employed in each column for each year. Is this possible with Power bi?
Solved! Go to Solution.
Hi, try with this (modified accord to your tables and Fields)
%byType = DIVIDE ( CALCULATE ( COUNT ( Table1[Employee] ) ), CALCULATE ( COUNT ( Table1[Year] ), ALLSELECTED ( Table1[Employee] ) ) )
Regards
Victor
Lima - Peru
How did you get the value to show in the column?
Hi, try with this (modified accord to your tables and Fields)
%byType = DIVIDE ( CALCULATE ( COUNT ( Table1[Employee] ) ), CALCULATE ( COUNT ( Table1[Year] ), ALLSELECTED ( Table1[Employee] ) ) )
Regards
Victor
Lima - Peru
How did you get the value to show in the column?
I can't see an obvious way to do this simply (unless you're happy for it to be a tooltip), you could try working around it by making a measure that calculates your percentage, adding that as another value to your chart, then setting your percentage to the same colour as the chart background (so it doesn't show up) and customising the data labels so that your employed/unemployed labels are turned off but your percentage is turned on.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |