Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I am analyzing a (gender equality) survey with 132 male and 93 female respondents. This gender imbalance in the sample influences the interpretation of survey questions, where men have a majority of the vote. How can I instead create a relative percentage of the votes per gender? So if 93/93 women vote YES, and 132/132 men vote NO, the visual should show a 100% men and 100% women. If 46.5/93 women vote YES and 66/132 men vote NO, then both visuals should show 50%.
So I would like to use the relative percentage of votes within that category of gender.
That means on the visual left, which describes just the respondents, it should show 100% on both bars.
Sample dashboard: https://blobstorage123123.blob.core.windows.net/random/Samplereport.pbix
Thank you so much!
Solved! Go to Solution.
@mmossel , Please find if the attached file after signature can help
hi @amitchandak,
Have you been able to download the sample report that I shared? Let me know, I've still not been able to solve the problem without you. Thank you!
@mmossel , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
On of the new measure for the first bar can be(assuming you are using measure)
divide([measure], calculate([measure], allexcept(Table, Table[gender])))
Hi @amitchandak
Thank you, it's in the description now. I'll link it here too: https://blobstorage123123.blob.core.windows.net/random/Samplereport.pbix
@mmossel , Please find if the attached file after signature can help
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
149 | |
117 | |
111 | |
106 | |
95 |