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 any way to add an additional filter for the PRODUCT/ENGAGEMENT classification?

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

When I share my report, viewers won't have access to the display pane to make this change, so it would be easier if I 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