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.
Hello. I have a percentage that I divided into 2 genders, male and female. It looks like this:
So, my problem is kinda complicated. I need to put dynamic text on my dashboard, that will show either all females scored higher that males, or opposite. Ideally, I would like to have the third case, if for example females scored higher in all bars, except something, then the text will be like:
"The female group scored higher in all attributes except for “smth” ".
Does anyone has an idea? I will be very gratefull.
Solved! Go to Solution.
@Gleb
Apologies for the late reply, I got distracted with some other business. Here is the sample file with he solution https://www.dropbox.com/t/x57u2iHQmfZyrYPv
Actually this need some improvement. It need to be more dynamic by interchanging between male and female (whoever scores more) and perhaps concatenate the lower scored answered and/or providing counts of higher and lower answers in order to have accurate presentation of the results.
Hi @Gleb
Yes that can be done. Would you please provide more details about your source data?
As I can't share real names and values, I'm trying to make similar:
a table like:
person_id | _question | _answer | _gender | |
1 . | some_quest? . | 1st_type . | male | |
2 . | some_quest? . | 1st_type . | male | |
3 . | some_quest? . | 2st_type . | female | |
4 . | some_quest? . | 3st_type . | male | |
5 . | some_quest? . | 3st_type . | female | |
6 . | some_quest? . | 1st_type . | female | |
7 . | some_quest? | 1st_type . | female | |
8 . | some_quest? . | 2st_type . | female | |
9 . | some_quest? . | 2st_type . | female |
Then I calculate simple percentage for each answer, when I divede number of people who answered each type of answer and devide by all people who answered this question by any answer, for example in this table the calculation for 1st_type of answer will be 4/9.
This percentage I report as bar chart where x-axis is calculated value, y-axis is type of answer and divide it by gender legend.
@Gleb
Apologies for the late reply, I got distracted with some other business. Here is the sample file with he solution https://www.dropbox.com/t/x57u2iHQmfZyrYPv
Actually this need some improvement. It need to be more dynamic by interchanging between male and female (whoever scores more) and perhaps concatenate the lower scored answered and/or providing counts of higher and lower answers in order to have accurate presentation of the results.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |