Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm really new to PowerBI and don't know any DAX yet 😞
I'm trying to create a column visual which shows values as a percentage of the sum of two values from another chart.
I've run a survey.
How do I do this?
Thank you very much for your help! 🙂
J
Hi @v-huizhn-msft and @davehus
I've attached some sample data. Thank you very much for your help!
Below is a onedrive link to some sample data.
https://1drv.ms/x/s!AjuHMtVQGOB-hz2pVR-p_GLHy5lY
J
Hi @JWorthy,
Please create two measures using the formula and add it in clusted column chart, you will get expected result as follows.
Percentage1 = DIVIDE(COUNT('Question 1'[Response]), CALCULATE(COUNTROWS('Question 1'),ALL('Question 1'))) count = COUNT('Question 2'[Response])
You can download the .pbix file for more details.
Best Regards,
Angelia
Hi @v-huizhn-msft,
Thanks for coming back to me.
I'm trying to do something slightly different. In the second chart, instead of calculating a % of the question 2 responses, I'd like to calculate the question 2 response as a % of 2 of the question 1 responses.
I'd like the second chart to show:
% of respondents who have chosen option A, B, C & D =
(Number of respondents who have chosen option A, B, C & D for question 2)
/
((Number of respondents who have selected option x for question 1)
+
(Number of respondents who have selected option y for question 1))
Does that make sense?
Thanks,
J
Hi - Have you got some sample data that you could provide?
Thanks
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |