Rankings from Microsoft Forms

Hi.

You just need to create a custom colum with a table inside and a rating to each of the elections, then deploy the table and calculate the Sum of ratings vs the Options

I created as example a table with the options selected separated by semicolons (ordered from more to less importance):

You need now to create a Custom Column with the following code

let
  optionsList = Text.Split([Option],";"),
  optionsTable= Table.FromList(optionsList),
  AddRating = Table.AddIndexColumn(optionsTable,"Rating", 3,-1)
in
  AddRating

You get a column with Tables

Simply Expand the tables

And you can the plot the new Column1 vs the sum of Rating (make sure Rating data type is a number)

Hope this resolves your question. Case it is, please mark it as a solution.