Forum Discussion

fpinero's avatar
fpinero
Frequent Visitor
5 years ago
Solved

How to show items with no data from an MS Forms dataset

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 p...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

fpinero , Not very clear. +0 to you measure can do

 

New measure = count(Table[Col1]) +0

fpinero's avatar
fpinero
Frequent Visitor
5 years ago

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.