Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need help with bar chart

Hi,    New to Power BI here.    If I have 20 Likert scale survey questions, can I create a dynamic bar chart that displays the agree/disagree response count for one question at a time? i.e. if I ...
Need Help
  • itsmebvk's avatar
    itsmebvk
    6 years ago

    Anonymous 

     

    Please watch attached video for steps. *** Note: there are many ways of doing it.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

itsmebvk 

Hey thanks for your reply. I'm really very new to Power BI and coding, would it be possible to break down the instructions further or link a video tutorial that demonstartes how to do this?

 

Thanks very much. 

itsmebvk's avatar
itsmebvk
Icon for Continued Contributor rankContinued Contributor
6 years ago

Anonymous  I am sorry I am not sure how to create video and link. Please follow below steps.

 

1)Assume that you have following data

 

 

2)Then Open Power BI Desktop, create a mesure as follows

 

 

3) Use following expression

 

Measure = count(Sheet1[Answer])
 
4)Then select Answers and New Measure columns to chart as highlighted below
 
 
 
5) Then select slicer as highlighted in 5step, then assign Question column to this.
 
Now should be able to play with it. 
 
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    itsmebvk 

    Thanks for the instructions! Based on the below I'm thinking perhaps my data is not set up correctly for Power BI... it is currently in this format:

     

     

    Will this still work for what I'm trying to do? 

    • itsmebvk's avatar
      itsmebvk
      Icon for Continued Contributor rankContinued Contributor
      6 years ago

      Anonymous 

       

      Please watch attached video for steps. *** Note: there are many ways of doing it.

       

    • VijayP's avatar
      VijayP
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Yes it will work. First UnPivot all Question Columns into One Column and follow my other instructions.

      You need to create a measure the way I have created and rest the same.