Split inconsistent value format in Power Query

[giordani2000]

In this power query, I have three different value format: attribute14 is $, ratio is in % and multiple is in (x). I need to split the values or move them to different columns. I want to move multiple to column F and ratio to column G. How can I do so in Power Query?

Then, I am creating a graph with the Y axis being the values (and I need the values to be in the correct format in different columns otherwise the chart doesn't update the format). File in this link.

Thanks.

Thanks.

[DOLEARY85]

Hi,

select the column (D) and on the transform tool bar select pivot, in the values select the values column (E), this should split the coulmns as needed.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[giordani2000 · Accepted solution]

Thank you @DOLEARY85 maybe I didn't explain myself clearly. I just overly simplified the exercise in this link. If I navigate within the slicer, the Y axis and the data labels format in the chart does not update. Is there a way to make it update automatically?. The alternative would be keeping $, % and x in a separate column but I need to keep the labels in one column so I can use a slicer as shown in this link.