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.
Hi - my MS Form has many questions with both single and multiple select. Such forms compile all results in an online Excel file, which is a dataset in my PowerBI used to create reports.
Now the problem is, when I create charts to display the different answers from the form, I cannot show items with no data in PowerBI. However, in the online "Responses" tab in MS Forms the charts show those items with no data (zero counts).
How can I achieve the same level of analytics in my BI report?
Thanks in advance!
Solved! Go to Solution.
Hi, @fpinero
According to your description, you said that you can’t make the chart display the items with no data. I think you can try to click on the “Show items with no data” button to make the blank value display, like this:
This is my test data:
Before turning on:
After turning on:
And you can get what you want.
You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @fpinero
According to your description, you said that you can’t make the chart display the items with no data. I think you can try to click on the “Show items with no data” button to make the blank value display, like this:
This is my test data:
Before turning on:
After turning on:
And you can get what you want.
You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@fpinero , Not very clear. +0 to you measure can do
New measure = count(Table[Col1]) +0
Thank you Amit, not sure I understand though.
The online form has questions with multiple options to choose from.
The online form analitycs shows me a chart with both chosen and not chosen options for each of the questions. But the dataset on PowerBI doesn't get the information of what options weren't chosen in each question, it only gets the chosen options from the question.
So, when I create a chart, it only shows options that were chosen in the response.
You can see the difference between the two charts. The first one doesn't have empty bars (menaing option not chosen from questions) while the second chart does.
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |