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
Hello All,
I have researched this for hours but have been unable to resolve it. Any help would be appreciated.
I have survey data. Of course, sometimes respondents do not answer every question.
Here is an example of my data:
Respondent ID | The class was very helpful |
1 | Strongly Agree |
2 | Agree |
3 | |
4 | Agree |
5 | Strongly Disagree |
6 | Agree |
7 | Strongly Agree |
8 |
I have a bar graph displaying the % of respondents who answered with each response. It is sorted in order (Strongly Agree, Agree, Disagree, Strongly Disagree)
Here is my dax:
I do not want to simply filter out the blanks in the visual because then the total percentages do not equal 100%, of course.
I should also add that I do not want to remove the entire row, as the person may have answered other questions on the survey but left that particular question blank.
Thank you for any help you can offer!
HI, @afaherty
use Visual level filter like below image made from your data
in advance filter option choose isnotempty for The class was very helpful column
Thank you, but as I mentioned, that means then that the bars in the graph do not add up to 100%. I would prefer to handle this via DAX.
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 |
---|---|
31 | |
14 | |
12 | |
10 | |
10 |