Power Query Inconsistent Data Format

[giordani2000]

Data for this graph comes from the metrics page, which was unpivoted using power query. The data is in one column but the format is inconsistent.

I think I need to keep the labels in one column and the data (consistent data format) in independent rows. How can I do so?I want to have three charts: one representing $, one representing % and one representing multiples. Fin the file in link below.

Thanks.

Combined Metrics_4Q'22 Master_V2_test.xlsx

[v-stephen-msft · Accepted solution]

Hi @giordani2000 ,

Unfortunately, the link can't be opened.

Well, you can pivot the columns again since your data was unpivotted.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.