Forum Discussion

phuang's avatar
phuang
Frequent Visitor
6 years ago
Solved

Survey data has hierarchy question, interaction frequency then rating (weight) - help!

Hello experts,   I need help to transform one survey question into a line graph with a frequency filter.   Below is the survey question: Here's the collected data imported to Power BI: ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

  • phuang's avatar
    phuang
    Frequent Visitor
    6 years ago

    Hi Greg,

     

    Thanks for the guideline, I've read and put together below.

     

    I expected to output line visual that shows the average rating of PRODUCT and ENGAGEMENT by X,Y, and Z which could be filtered by the Frequency (Daily, Weekly, Monthly, Quarterly, Yearly, Never).  I want to know how the Frequency changes the Avg. rating.

     

    I created the Avg. rating line visual by unpivoted the X, Y, Z PRODUCT/ENGAGEMENT columns but I don't know how to make the Frequency works with the visual.   I tried unpivoted the Frequency columns with the PRODUCT and ENGAGEMENT columns but it messed up the Avg. rating calculation.

    Business UnitX FrequencyX PRODUCT RatingX ENGAGEMENT RatingY FrequencyY PRODUCT RatingY ENGAGEMENT RatingZ FrequencyZ PRODUCT RatingZ ENGAGEMENT Rating
    A(Blank)(Select none)(Select none)   Monthly  
    BYearly  Quarterly34Yearly33
    CQuarterly33Yearly33Yearly33
    DNever  Never     
    EYearly22Never  Monthly33
    FNever  Never  Quarterly22
    G         
    H      Monthly33
    I         
    JYearly32Yearly  Monthly33
    K         
    AYearly33Yearly33Yearly33
    BYearly13Quarterly32Quarterly33
    CNever  Yearly33Monthly44
    DNever  Never  Quarterly33
    DNever  Never  Yearly3 
    C         
    ENever33Never33Yearly33
    F      Yearly33
    INever  Never  Never  
    JNever  Never  Quarterly33
    KDaily22Yearly  Yearly2 

     

    Please let me know if you'd like me to provide more information/details. 

     

    Thanks in advance for your time helping me.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

      You may download the PBI file from here.

      Hope this helps.

      • phuang's avatar
        phuang
        Frequent Visitor
        6 years ago

        Hi Ashish,

         

        Thank you so much!  It works perfectly!  Your file really helps me out 😊

        I had spent many hours on this visual and felt so lost.

         

        One more question, is there a way to add an additional filter for PRODUCT / ENGAGEMENT rating?

        I can show only the PRODUCT Avg. by deleting the Average engagement rating from the Values in the Visualization panel.

        When I share my report, viewers won’t have access to the visualization panel to do this change, so it would be easier if I provide it in the Filters panel.  Viewers can view either PRODUCT or ENGAGEMENT or both.

         

        I played with your file and did below:

        Axis – Attribute.1 X,Y, Z – done

        Filter – Business Unit – done

                      Product/Engagement – not sure if this is doable…

        Modified PBI file

         

        Thank you.

        Penny