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

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