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.

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

Hola Ashish,

Thanks a lot! It works perfectly! Your file really helps me 😊

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

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

I can only display the Average product by removing the average interaction rating of the values in the Display pane.

When I share my report, viewers won't have access to the display pane to make this change, so it would be easier if you provided it in the Filters panel. Viewers can watch PRODUCT or ENGAGEMENT or both.

I played with your file and I did it below:

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

Filter – Business Unit – done

Product/Commitment – I'm not sure if this is feasible...

Modified PBI file

Capture.JPG

Thank you.

Penny