Forum Discussion
Weighted average - multiple category
Hi, i am trying to do a weighted average with mulitple categories. I need to multiply the "proportion" by the "capability" depending on filters selected. I have 3 filters: location, platform and...
amitchandak they are both columns and really not returning the good value. Here's the table:
and the output visual is a bar graph by platform (Y axis is in %)..
HI JCB,
Perhaps you can try to do unpivot column on your value fields to convert them to attribute and value. Then you can use the attribute field on the legends to group these values.
Unpivot columns (Power Query) (microsoft.com)
Regards,
Xiaoxin Sheng